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

  • Keep to one post, it'l be easier to track your solutions\answers. Already answered at

    http://www.sqlservercentral.com/Forums/Topic1359994-1550-1.aspx

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

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