How to: Move a Database
As the database administrator, you can move a database from one location to another. Remember that the corresponding sharing permissions are not moved. You must secure your database again in the new location.
To move a database by copying:
In Windows Explorer, copy all database directories and files to the new database share.
Use the procedure How to: Add a Database to add a new database at the new location.
Secure your database in the new location, as described in Securing a Database.
Delete the old database files from the new location.
Notify the users of the new database location.
Delete all the directories from the old database share.
To move a database by archiving and then restoring it:
Archive your current database. For more information, see How to: Archive a Database.
In the new location, restore the database. See How to: Restore a Database from an Archive.
Secure your database in the new location, as described in Securing a Database.
Notify the users of the new database location.
Delete all the directories from the old database share.
See Also
Tasks
How to: Add a Database
How to: Archive a Database
How to: Restore a Database from an Archive