How To Repair A Suspect Database In MSSQL

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.

Steps to fix:

  1. Open Microsoft SQL Server Management Studio and connect to your database
  2. Click the New Query button
  3. Paste the following SQL script into your New Query page replacing [YourDatabase] with the name of your database.

  4. Click Execute

Your database should no longer be tagged as (suspect) and you should be able to access it.

0

About the author

Janaki(http://mjanaki.com) -

A Software developer with 9+ years of experience in multiple technology projects across web, mobile, and cloud applications with expertise in PHP, C#, MySQL, Web services and open source platforms.

Similar Posts

Install MariaDB 10.1.14 on CentOS 7
CentOs Vagrant Configuration file

Leave a reply

required*

Eye Test: * Time limit is exhausted. Please reload CAPTCHA.