Database going into suspected mode !!! Urgent

  • Primary server databases are working fine but my secondary databases are going into suspected mode.

    No of databases 20 all are log shipped.

    2 of my database went into suspected mode so i recovered it from my last nite full back and restored the remaning t-log backup with no issue.

    This shows my transaction logs are not corrupted.

    Now again today of my standby database went into suspected mode.Also i m able to restore the transaction log with norecovery but cannot with standy as it says it is in sspected mode.

    My primary databases are working fine and my full backup,t-log backup are fine with no issue.

    I want to know why my databases is going into suspected mode which is in standby mode.

    Kindly suggest.

  • Sqlserver 2008 R2 and windows 2003

  • Have you checked the windows application event log and the sql server log for any possible error messages?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • If this is occurring over & over, I'd start worrying about my hardware. Have you run consistency checks on these databases to determine what's wrong?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Open up the SQL error log and post all errors that you see relating to the suspect database.

    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
  • PFA error Logs,

Viewing 6 posts - 1 through 5 (of 5 total)

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