It is very important to understand DBCC CHECKDB. Make sure you run DBCC CHECKDB periodically and that if you do find some sort of corruption you address it immediately – both the current problem in the SQL Server database and the underlying problem that caused it. · How often should we run CHECKDB? o Continue reading “DBCC CHECKDB / Database Integrity”
Tag Archives: corruption
Backing up a corrupted SQL Server database
I had a question about how to do a backup and skip a corrupted block of data. First, DO NOT DO IT unless you absolutely have to, such as when you are taking a backup prior to trying to fix the corruption (which means you should be on the phone with Microsoft PSS). If you doContinue reading “Backing up a corrupted SQL Server database”