Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database going into suspected mode !!! Urgent Expand / Collapse
Author
Message
Posted Monday, September 17, 2012 12:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 3, 2014 2:59 AM
Points: 313, Visits: 538
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
Post #1359997
Posted Monday, September 17, 2012 2:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 6,760, Visits: 14,410
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"
Post #1360023
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse