• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Use copy database wizard or backup and restore on sql server

We are getting a new server and we need to transfer a 15g database to the new one.  What would be the fastest way to do this....using the copy database wizard or doing a backup and restore?  Also can this be done during production or will it have to be after hours?

Thanks
0
tbailey922
Asked:
tbailey922
2 Solutions
 
imran_fastCommented:
>>What would be the fastest way to do this....using the copy database wizard or doing a backup and restore?

detach the databases copy mdf and ldf to the new server and attach them

transfer logins between sql
==========================
http://support.microsoft.com/kb/246133/

second is both sql are same (2005 or 2000)
use copy database wizard

third
backup and restore.

0
 
SireesCommented:
<<Also can this be done during production or will it have to be after hours?>>

You can do backup and restore..

Are you moving production database to another server?

If so, then its always better to do it off  hours. As usual don't forget to take the backup first.


0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now