Move a DB to another server 2

[TinRam]

Hello....

If I have a DB on a test sever and wanted to move it to another... is this possible? How can this be done?

Thanks!

 

[vanoordt]

Check out sp_attach_db

 

[link9]

Use the DTS Wizard.

Import/Export is a breeze with that.

 

[foxbox]

o make a full backup of YourDatabase.
o create a new database YourDatabase on your test server
o restore the backup to this database and check 'Force restore over existing database' on the Options-tab.
o When the folder with the MDF/LDF files are different on both machines you also must change the path in the 'Restore database as' fields.


br
Gerard
(-:

 

[syntax18]

If u are using SQL server 2000 u can detach the database ,copy the data file and the log file to a new location or to the new server and then u can use the attach database feature..

 

[castellu]

Using the sp_attach_db is the route I have chosen in the past. Detaching the database and copying the data file and log file worked great for me. The only thing to be wary about is whether you are using SQL 7 or SQL 2000. Using the sp_attach_db procedure is a snap, but in SQL 7 the servers have to have the same sort order and unicode collation settings. If you selected the default install on both machines for SQL 7 then this is a breeze. If the two servers have different settings then this is a nightmare. Let me know if you need more info on this..... -------------------------------------
castellu