How To Repair A Suspect Database In MSSQL Server Database

Issue You have a database in MS SQL that is tagged as (suspect) and you are unable to connect to the database.

Possible Causes

The database could have become corrupted.

There is not enough space available for the SQL Server to recover the database during startup.

The database cannot be opened due to inaccessible files or insufficient memory or disk space.

The database files are being held by operating system, third party backup software etc.

There was an unexpected SQL Server Shutdown, power failure or a hardware failure.

Resolution These steps require you to have Microsoft SQL Server Management Studio installed on your computer. If you do not have this installed please install Microsoft SQL server Management Studio to connect database server.