January 20, 2013 at 11:07 pm
any query to Check the log for database corruption.?
January 20, 2013 at 11:22 pm
Here is an article about alerts you can configure about corruption.
http://www.sqlsoldier.com/wp/sqlserver/day10of31daysofdisasterrecoverymonitoringforcorruptionerror
Do you have checkdb jobs configured to run on a regular basis?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2013 at 2:50 am
sumith1andonly1 (1/20/2013)
any query to Check the log for database corruption.?
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Run on a regular basis.
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply