Deleting a Database

You can delete a database when it is no longer needed or if it is moved to another database or server. When a database is deleted, the files and their data are deleted from the disk on the server. Once a database is deleted, it is permanently deleted and cannot be retrieved without using a previous backup.

It is recommended that you back up the master database after a database is deleted because deleting a database updates the system tables in master. If master needs to be restored, any database that has been deleted since the last backup of master will still have references in the system tables and may cause error messages to be raised.

To delete a database

         

To create a database backup

         

See Also

Backing Up and Restoring Databases


(c) 1988-98 Microsoft Corporation. All Rights Reserved.