Moving Databases
Sometimes you need to move a database or database file. There are several ways to accomplish this task:
Make a database backup and then restore it to a new location.
Alter the database, specifying a new location for the database file.
Detach the database and then reattach the database, specifying an alternate location.
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.