Web Hosting Community Forums by ASPnix
Client Login Area
LiveZilla Live Chat Software
Results 1 to 2 of 2

Thread: How to recover SQL Server database from suspect mode?

  1. #1

    Lightbulb How to recover SQL Server database from suspect mode?

    Please use this script to recover database from suspect mode in MS SQL Server 2008, 2005 through SQL Server management Studio.

    Code:
    EXEC sp_resetstatus 'yourDBname';
    ALTER DATABASE yourDBname SET EMERGENCY
    DBCC checkdb('yourDBname')
    ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
    ALTER DATABASE yourDBname SET MULTI_USER



    Note:
    change yourDBname with database name you want to recover from suspect mode.
    References:
    Last edited by Atiq; September 1st, 2010 at 03:55 PM. Reason: Add ASPnix Support reference

  2. #2
    Administrator Roma's Avatar
    Join Date
    June 27, 2005
    Location
    Denver, CO
    Posts
    4,054

    Default

    Great post! very helpful
    Roma
    Friendly ASPnix Administrator


    http://aspnix.com
    roma@aspnix.com
    1-877-427-7649



    ASPnix on Facebook

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •