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?
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 …
-
What does it mean when a SQL Database is SUSPECT?
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 …
-
repair_rebuild vs repair_allow_data_loss
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 …
-
Do Not Run REPAIR_ALLOW_DATA_LOSS
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 …
-
Location of Master MDF files
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. …
-
CHECKDB WITH NO_INFOMSGS
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 …
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Leave a Reply