|
|||||||||
Your databases are stored in two special files which are managed by SQL Server Desktop Engine. Do not attempt to move these files using Windows Explorer. If you�ve run out of disk space, or if you�re upgrading your hard disk, or if you want to change the location of these two files for any reason, follow these instructions for backing up and restoring your database. The overview of want you�ll need to do to move your database files is simple:
Follow the instructions for each step as detailed in those documents. For step two, use a name for the restored database that�s different from the original database name (all active databases must have distinguishing names). When restoring the backup file you can place the database on any drive or directory that has adequate space. |
See also
The difference between database files and backup files
Attaching a database from a previous installation
The database version control utility
Last reviewed March 25, 2004
|
|||