moving a database from one server to another 1

[db2mainframer]

What is the best way to do this?

 

[nowayout]

do back up and restore.

 

[alexerm]

If the servers are on the same network, you may use "Copy Database Wizard". Otherwise you could do it by creating and restoring backups

 

[nowayout]

then copy wizard would be fine.

 

[tlbroadbent]

I prefer to move databases using Detach/Attach or Backup/Restore. The copy database wizard is more difficult to use, more error prone and can actually omit some objects when copying. Check out the following article for ways to move databases between servers.

HOW TO: Move Databases Between Computers That Are Running SQL Server

http://support.microsoft.com/default.aspx?kbid=314546

If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm