So, you have discovered CheckDB is reporting errors on your SQL Server database or on a table in your database. What do you do? REPAIR_ALLOW_DATA_LOSS seems like and quick and easy fix right? But do you actually know what you’re …

Beware – REPAIR_ALLOW_DATA_LOSS Vs REPAIR_REBUILD Read more »

Please join me on Saturday March 16 in Victoria BC Canada for my SQL Saturday presentation on the Basics of Database Corruption Repair. Here is the session, the Basics of Database Corruption Repair. Duration: 60 minutesTrack: AdminLevel: Intermediate Your database …

Basics of Database Corruption Repair Read more »

As a DBA you regularly schedule backups you might have regular full backups, incremental backups and hopefully regular backups. Over time you might realize that your error log is not longer filled with errors, but instead a majority of your …

Silencing Backup Messages with Trace Flag 3226 Read more »