Tag: repair_allow_data_loss

By Posted on Posted in Corruption No Comments Tagged with , , , ,

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 »

By Posted on Posted in SQL Server No Comments Tagged with

Steve Stedman So years ago, when my kids were growing up, and they were watching the Discovery Channel, or Animal Planet, or whatever it was where the Crocodile Hunter was there. And I remember Steve Irwin, the Crocodile Hunter used to say Danger, Danger, Danger, and he’d go in and like deal with some crocodile or something like that. And …

Danger Danger Danger – REPAIR_ALLOW_DATA_LOSS Read more »