Moving a Database
To move a database or a database file to another server or disk:
- First, detach the database from the SQL Server, as described in Attaching and detaching a database.
- Move the database files to the other server or disk (e.g. using Windows Explorer).
- Attach the database as described in Attaching and detaching a database, using the new location of the moved files.
Once the attachment takes place, the moved database can be added to the Database Manager's tree structure. Its properties show the new path.
This function requires exclusive access to the database, so any other applications must be disconnected from the database before it is applied.