You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > Access It! > Miscellaneous > SQL Scripts > SQL Server Database Has Been Marked Suspect
SQL Server Database Has Been Marked Suspect
print icon

Symptoms

The database configuration utility fails to open, and when using SQL Server
Management Studio, the database is marked Suspect.

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
Run the following SQL Statement against the Suspect database to reset the mode. If the script does not resolve the issue, consult your SQL DBA or RS2 Technical Support for further assistance.

More Information

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

Replace DataBaseName with the name of the Suspect database.


scroll to top icon