Leading provider of Account Software
Questions? We got answers!
Support Center > Knowledge base> Article: How to repair a Suspect database in Optimum

How to repair a Suspect database in Optimum

Article ID: 63370 Email Print
Question
How to repair a suspect database in Optimum

Answer

Some of the reasons why an SQL Server database can be marked as SUSPECT

  • Database could have been corrupted.
  • There is not enough space available for the SQL Server to recover the database during startup.
  • Database cannot be opened due to inaccessible files or insufficient memory or disk space.
  • Database files are being held by operating system, third party backup software etc.
  • Unexpected SQL Server Shutdown, Power failure or a Hardware failure.

1. First , you need to go to Microsoft Management SQL Tools to check if the database stated as "Suspect". To install the Microsoft Management SQL Tools, you can install it from our intallation cd\Dependencies\SQLManagement2012_x86_ENU - for 32bit windows or SQLManagement2012_x64_ENU for 64 bit windows

2. After confirm that it is a "Suspect" database, login to Microsoft SQL Management Tools with your login instance name e.g. SERVER\QNEBSS with the user name of 'sa' and password 'QnE123!@#'

3. Click New Query and copy the script below to the "SQLQuery1.sql-se..s.master(sa(52))*"  page. Replace the <database> with your database name. Click Execute to run the script

        ALTER DATABASE <database> SET EMERGENCY

4. After finish, click New Query and copy the following sciprt and click Execute button.

       DBCC CHECKDB (<database>)

5. After finish, click New Query and copy the following sciprt and click Execute button.

       ALTER DATABASE <database> SET SINGLE_USER WITH ROLLBACK IMMEDIATE

6. After finish, click New Query and copy the following sciprt and click Execute button.

       DBCC CHECKDB (<database>, REPAIR_ALLOW_DATA_LOSS)

7. After finish, click New Query and copy the following sciprt and click Execute button.

      ALTER DATABASE <database> SET MULTI_USER

8. After finish, you may try to login to the database.

    

 


related articles

Article Details
Views: 1358 Created on: Mar 26, 2015
Date updated: Mar 26, 2015
Posted in: Optimum, Database

Poor Outstanding