This documentation is archived and is not being maintained.

How to: Move a Database

Visual Studio 2005

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

Show: