Weekly Summary - June 12, 2020

It was a busy week this week, but I was able to create several blog posts relating to corruption.

Does a corrupt database really need to be repaired?June 11, 2020
At Stedman Solutions, LLC the team and I do many database repairs from simple things that take just a few minutes to larger repairs that take many days to repair. Since 2015 we …
Latest 100 PostsRead More »
What does it mean when a SQL Database is SUSPECT?June 10, 2020
First rules about a database being in suspect mode: Do not trust anyone who just says follow these steps and it will always fix a SQL database that is SUSPECT. Do not listen …
Latest 100 PostsRead More »
repair_rebuild vs repair_allow_data_lossJune 9, 2020
Yesterday I posted about how repair_allow_data_loss should never be used with CHECKDB or CHECKTABLE. Today I want to share the difference between repair_rebuild vs repair_allow_data_loss. First off, after reading the post about never …
Latest 100 PostsRead More »
Do Not Run REPAIR_ALLOW_DATA_LOSSJune 8, 2020
So often I get the call from someone needing help with repairing a corrupt database, and then they tell me that they ran CHECKDB with REPAIR_ALLOW_DATA_LOSS and at that point I realize it …
Latest 100 PostsRead More »
Location of Master MDF filesJune 7, 2020
The following question was asked on my website: What file does SQL Server use to find the location of the master.mdf file? website question Without context this could mean a few different things. …
Latest 100 PostsRead More »
CHECKDB WITH NO_INFOMSGSJune 6, 2020
When running DBCC CHECKDB, you will often times get screens of information back stating that the database is all okay, and that it checked every table. This can be quite tedious when you …
Latest 100 PostsRead More »