After you have performed the preceding steps for all databases on the failed device, use drop database to drop each database.
If 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)
If you are using a replicated database, use dbcc dbrepair to load a dump from a previous release of Adaptive Server to a more current version. For example:
Loading a dump from a production system of an earlier release of Adaptive Server into a test system of the current release Adaptive Server, or,
In a warm standby application, initializing a standby database of the current release of Adaptive Server with a database dump from an active database of an earlier release of Adaptive Server
See the Error Message and Troubleshooting Guide and Reference Manual: Commands for more information about dbcc dbrepair.
