How to create a copy of an active database
The following instructions were originally created by Henk Griesshaber (SAP?).
They are merely mirrored here to spread the information.
background
In the new versions of SAP Business One it is not possible to transfer company data from one company to another (from within Business One).Yet you might need to transfer a database for a number of reasons:
- to create a backup of a live system
- to create a developing system
- to transfer changes from development into a live system
Procedure
By far the fastest and safest way to copy a database is to use the backup and restore feature of the Enterprise Manager (SQL Server 2000 Client Component).
Example: Creating a copy of the standard Database SBO_DemoUS
1. Create a backup
Create a backup of the desired database...using the backup database function, of course 😉
Leave the default settings and add a destination where you want to save the backup.
Define the name of the backup and select OK.
The destination folder and file name has now been added.
Select OK.
This starts the back-up process.
2. Restore database
Restore this database, but assign it to a new database name (!).
This creates a new database as copy of the original database
Select Restore from the database folder.
In the Restore as Database field, enter a new (!) name.
In the Show backups of database field, select the original database from which you would like to see the backups.
Select the database to be restored.
Then select OK to start the restore process.
Result
A second (new) database is created as copy of the original database.
It is automatically attached to the server and will appear in SAP Business One (need to scan again!).
Important Note
If you have trouble accessing your newly created database, note that SQL Server does not /cannot create exact copies of your database users.
Deleting and re-creating the users will allow SAP Business One to access the database.
All due credits to Henk Griesshaber.
Henk I could not contact you and this was just too good to be left sleeping on my workstation.
Lutz Morrien
6 Comments
