Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Lost MY Copy Database Menu

Author  Topic 

viperbyte
Posting Yak Master

132 Posts

Posted - 2011-12-12 : 06:53:43
A few days ago I copied my test database to my client's server using the copy database wizard. I made some changes to my test database and added some SPs and wanted to copy the database to the client's server. So I deleted the tables on the clients' db first. Now that I'm ready to copy the database, I can't find the copy database wizard. I right click on the database in management studio, click tasks and can't find the copy database wizard. Can anyone super please help me with this?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-12 : 13:01:12
Don't bother with the copy database wizard. Use backup/restore or detach/attach methods instead. Copy database wizard does not give you an exact copy, the other methods do.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -