Copy a database with Sql Server 2005

With Sql Server 2005, you no longer use the DTS wizard to move objects from one Sql Server database to another.  Go into the Sql Server Management Studio, select "Copy Database", and then follow the instructions.

Wally

2 Comments

  • Sure but you have to be sysadmin on both servers! Big step backwards from DTS. I need to copy a db from a hosted server. The only good way I see is to install the sql server 2000 client....

  • still, the copy wizard can't be accesed if you're not sysadmin. problem when you have to copy from network solutions to somewhere else or viceversa...

Comments have been disabled for this content.