September 17, 2012 at 12:51 am
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.
September 17, 2012 at 12:55 am
Sqlserver 2008 R2 and windows 2003
September 17, 2012 at 1:20 am
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" 😉
September 17, 2012 at 4:19 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 17, 2012 at 5:09 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 18, 2012 at 6:18 am
PFA error Logs,
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply