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:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, February 06, 2014 5:18 AM
Points: 290, Visits: 524

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
Posted Monday, September 17, 2012 12:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, February 06, 2014 5:18 AM
Points: 290, Visits: 524
Sqlserver 2008 R2 and windows 2003
Post #1359995
Posted Monday, September 17, 2012 1:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:15 PM
Points: 5,951, Visits: 12,822
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"
Post #1360004
Posted Monday, September 17, 2012 4:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:51 AM
Points: 14,788, Visits: 27,264
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
Posted Monday, September 17, 2012 5:09 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:24 AM
Points: 41,517, Visits: 34,432
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
Posted Tuesday, September 18, 2012 6:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, February 06, 2014 5:18 AM
Points: 290, Visits: 524
PFA error Logs,



  Post Attachments 
ERROR_LOG.rar (19 views, 86.00 KB)
Job History_123.txt (26 views, 132.48 KB)
Post #1360737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse