Moving your database files
   compleat botanica    using the software    databases    Special issues   
 
 
   

 

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:

1

Backup your database

2

Restore the backup copy of your database using a new location

3

Delete your original database

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

   Using the fast create option

   Attaching a database from a previous installation

   The database version control utility

   Special database issues

Last reviewed March 25, 2004   

 

  Order your copy here