1. Recovering SQL Server Database From Suspect Mode

    Follow below steps to recover database from suspect mode:
    1. ALTER DATABASE [database_name] SET EMERGENCY 
    2. DBCC checkdb('database_name') 
    3. ALTER DATABASE [database_name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
    4. DBCC CheckDB ('database_name', REPAIR_ALLOW_DATA_LOSS)
    5. ALTER DATABASE [database_name]  SET MULTI_USER

    If it does not work for you, then go for third party tool or restore database from available backups.
    0

    Add a comment

Subscribe
Subscribe
Favorite Links
Blog Archive
About Me
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.