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 » SQL Server 2008 Administration » 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:51 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.

Post #1359994

samsql

Posted Monday, September 17, 2012 12:55 AM

SSC Veteran

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

Sqlserver 2008 R2 and windows 2003

Post #1359995

Perry Whittle

Posted Monday, September 17, 2012 1:20 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:36 AM
Points: 5,201, Visits: 11,153

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

Post #1360004

Grant Fritchey

Posted Monday, September 17, 2012 4:19 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 6:59 AM
Points: 13,378, Visits: 25,163

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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1360077

GilaMonster

Posted Monday, September 17, 2012 5:09 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 37,712, Visits: 29,966

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 2008, MVP
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

Post #1360110