May 12, 2010 | DBCC CHECKDB, Integrity Checks, Snapshots, SQL Server 2005, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication |
Ever come across a scary error in the SQL Server log when running CHECKDB against your databases. The error looks something like this: 1 transactions rolled back in database ‘CHECKDB’ (32). This is an informational message only. No user action is...
May 5, 2010 | DBCC CHECKDB, Integrity Checks, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals, SQLServerPedia Syndication |
I like to run integrity checks against my databases very regularly, sometimes daily if I can get away with it. For some of the larger databases that I manage I change how this is run but on my consolidated instances which can house several different smaller databases...
