Saturday, February 25, 2012

Move databases between local drives ?

How can I move a database between local drives or paths on
the same computer that is running sql server?Backup the database, do a test restore.
Either
detach the database (sp_detach_db)
move the files
attach the database (sp_attach_db)
or
drop the database
restore from backup with move.|||Oops - duplicate post.

No comments:

Post a Comment