Database going into suspected mode !!! Urgent

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Data Corruption (SS2K8 / SS2K8 R2) » Database going into suspected mode !!! Urgent...

Database going into suspected mode !!! Urgent

Rate Topic

Display Mode

Topic Options

Author

Message

samsql

Posted Monday, September 17, 2012 12:57 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, March 21, 2013 5:40 AM
Points: 288, Visits: 517

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

Perry Whittle

Posted Monday, September 17, 2012 2:20 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 5,204, Visits: 11,163

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" Wink

Post #1360023

« Prev Topic | Next Topic »

Permissions