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.
