X
GO
Support

Our online helpdesk allow our customers to log their issues as well as review the status of their calls and search our extensive knowledge-base for answers to common questions. Our Online help file can be accessed through this link. You can also email support at Support@LinkTechnologies.com.au

Product Features can be viewed at this link.

Knowledge Base containing common solutions are in the forums below. You can search our internal call logs at this link.

Forum
HomeHomeLink Technologi...Link Technologi...Product Support...Product Support...How to recover database from Suspect modeHow to recover database from Suspect mode
Previous
 
Next
New Post
12/24/2015 10:52 AM
 

Things that can cause a database to go into Suspect mode:

  1. Improper shutdown of the SQL Server Service (like "End Task" of the service, hard restart of machine)
  2. Hardware failure
  3. Not enough disk space 
  4. Various corruptions of db file (mdf or ldf)
  5. The transaction log has been corrupted, deleted etc.

Steps to recover database from SUSPECT: Logon to your server and ensure that you have sufficient disk space for data and log. Ensure your hard drives are healthy. Before proceeding the cause of failure needs to be resolved.

  1. Login to SQL Server using "System Administrator" account

    Figure 1: Database LINKSOFT showing as SUSPECT

  2. Reset the status of SUSPECT
    EXEC sp_resetstatus 'LINKSOFT';

    Figure 2: Reset database status

  3. Set database to Emergency mode
    ALTER DATABASE LINKSOFT SET EMERGENCY

    Figure 3: Database mode set to Emergency

  4. Set database to single user mode
    ALTER DATABASE LINKSOFT SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    Figure 4: Database set to Single User

  5. Check db for errors and allow for auto repair
    dbcc checkdb('LINKSOFT',REPAIR_ALLOW_DATA_LOSS)

    Figure 5: Check database with allow auto repair

  6. Set database to multi user mode
    ALTER DATABASE LINKSOFT SET MULTI_USER

    Figure 6: Database mode changed to Multi User

At this point the database should be operational.

 
Previous
 
Next
HomeHomeLink Technologi...Link Technologi...Product Support...Product Support...How to recover database from Suspect modeHow to recover database from Suspect mode