InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 09:06:20 GMT20http://www.sqlservercentral.com/Forums/Topic1359994-1550-1.aspxPFA error Logs,Tue, 18 Sep 2012 06:18:15 GMTsamsqlhttp://www.sqlservercentral.com/Forums/Topic1359994-1550-1.aspxOpen up the SQL error log and post all errors that you see relating to the suspect database.Mon, 17 Sep 2012 05:09:46 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1359994-1550-1.aspxIf 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?Mon, 17 Sep 2012 04:19:27 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1359994-1550-1.aspxHave you checked the windows application event log and the sql server log for any possible error messages?Mon, 17 Sep 2012 01:20:07 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1359994-1550-1.aspxSqlserver 2008 R2 and windows 2003Mon, 17 Sep 2012 00:55:11 GMTsamsqlhttp://www.sqlservercentral.com/Forums/Topic1359994-1550-1.aspxPrimary 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.Mon, 17 Sep 2012 00:51:39 GMTsamsql