How do I repair a SQL Database marked Suspect? Follow

Overview

Sometimes you will encounter a sa password error that standard troubleshooting does not repair. In these cases, check the database status from the SQL Server Management Studio.

 

Cause

A SQL Database is marked suspect when there is database corruption, or missing log files. The SQL Server error logs may provide additional information as to the cause of the issue.

 

Resolution

If you see (Suspect) following the database name, run the following scripts on the database:

EXEC sp_resetstatus 'DataBaseName';
ALTER DATABASE DataBaseName SET EMERGENCY
DBCC checkdb('DataBaseName')
ALTER DATABASE DataBaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('DataBaseName', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE DataBaseName SET MULTI_USER

Once you have run the SQL script, the suspect database should reset.  If it does not, consult with your Tier 2 support or Systems.

Have more questions? Submit a request

Comments

Powered by Zendesk