Database ‘%.*ls’ is not marked suspect. You cannot drop it with DBCC.

Details
Product: SQL Server
Event ID: 2573
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: Database ‘%.*ls’ is not marked suspect. You cannot drop it with DBCC.
   
Explanation
In earlier versions of SQL Server, DBCC DBREPAIR was used to drop databases that were suspect. To use DBCC DBREPAIR to drop a database, the suspect status must be true for the specified database.

Important DBCC DBREPAIR is included in SQL Server 2000 for backward compatibility only. It is recommended that you use DROP DATABASE to drop damaged databases. In a future versions of SQL Server, DBCC DBREPAIR may not be supported.

   
User Action
To see if a database has been marked suspect, execute the following statement (replace ‘MyDatabaseName’ with the actual database name):

SELECT DATABASEPROPERTYEX( ‘MyDatabaseName’ , ‘Status’)

To drop a suspect database, use the DROP DATABASE command.

Related:

Leave a Reply