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:

1. In Windows Explorer, copy all database directories and files to the new database share.

2. Use the procedure How to: Add a Database to add a new database at the new location.

3. Secure your database in the new location, as described in Securing a Database.

4. Delete the old database files from the new location.

5. Notify the users of the new database location.

6. Delete all the directories from the old database share.

To move a database by archiving and then restoring it:

1. Archive your current database. For more information, see How to: Archive a Database.

2. In the new location, restore the database. See How to: Restore a Database from an Archive.

3. Secure your database in the new location, as described in Securing a Database.

4. Notify the users of the new database location.

5. 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

Concepts

Securing a Database