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 doing? Well, if you read the error messages you might see that repair_allow_data_loss is the minimum repair level for the …
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 is running fine month after month with no problems. Suddenly someone reports that their query won’t run. They get an …
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 error log is filled with backup messages. “Backup Database successfully … “, “Database backed up…”, “Log was backed up”. This …