Post reply

Database in suspect Mode

  • August 27, 2015 at 4:10 am

    #320136

    Hi All

    I have a one database in suspect mode after converting it to a VM (VMware environment, physical box consist of windows 2003/sql2005/sharepooint2007) and I have tried the following

    EXEC sp_resetstatus ''

    ALTER DATABASE SET EMERGENCY;

    DBCC CHECKDB('');

    ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    DBCC CHECKDB ('', REPAIR_ALLOW_DATA_LOSS);

    ALTER DATABASE SET MULTI_USER;

    to no avail... can I just delete this one database and restore from backup?

    any info would be greatly appreciated...

    Thanks

  • August 27, 2015 at 4:19 am

    #1822697

    Restore from your last good backup (plus log backups)

    Repair is usually a last resort for when you don't have backups.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 31, 2015 at 12:30 am

    This was removed by the editor as SPAM

  • October 27, 2015 at 5:30 am

    This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply