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… Read More »Does a corrupt database really need to be repaired?
First rules about a database being in suspect mode: A SQL database that is SUSPECT implies that it was unable to completely start up after… Read More »What does it mean when a SQL Database is SUSPECT?
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.… Read More »repair_rebuild vs 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… Read More »Do Not Run REPAIR_ALLOW_DATA_LOSS
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… Read More »Location of Master MDF files
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… Read More »CHECKDB WITH NO_INFOMSGS
Recently I had a project where I needed to add a number of logins as SQL Server sysadmin users to several SQL Server instances. Rather… Read More »Script to bulk add SysAdmins to SQL Server
Here is my weekly summary of recent blog posts for the last 7 days. Script to bulk add SysAdmins to SQL ServerJune 5, 2020 Recently… Read More »Weekly Summary – June 5, 2020
Recently we had a new customer contact from someone with a corrupt database. They were getting corruption error #824, which usually indicates there is some… Read More »Another Successful Corrupt Database Repair
In 2015, around the time I started Stedman Solutions LLC, I created the Database Corruption Challenge as a way to share knowledge of how to… Read More »Database Corruption Challenge