Dropping the databases

After you have performed the preceding steps for all databases on the failed device, use drop database to drop each database.

NoteIf tables in other databases contain references to any tables in the database you are trying to drop, you must remove the referential integrity constraints with alter table before you can drop the database.

If the system reports errors because the database is damaged when you issue drop database, use the dropdb option of the dbcc dbrepair command:

dbcc dbrepair (mydb, dropdb)

See the Error Message and Troubleshooting Guide for more information about dbcc dbrepair.