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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.