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
At Stedman Solutions we work with our clients a variety of different consulting agreements from fixed price projects to ongoing hourly work. One of the… Read More »SQL Server Mentoring – what we offer
When working with clients on fixing their corrupt SQL Server databases we run into some common beliefs about corruption that are not quite true, such… Read More »Confusion with Database Corruption