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 using repair_allow_data_loss, and you will understand that repair_allow_data_loss simply throws away pages. Next what repair_rebuild attempts to do is to rebuild pages in non-clustered indexes that are …
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 is going to be more difficult to get all their data back and repaired. When working with CheckDB and SQL Server, whether you are on SQL Server …
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. Are you trying to find out where master.mdf is located, or are you trying to move it? The answer is its not saved in a config file, …
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 are trying to search through thousands of lines of output to see where the real error is. You can use the WITH NO_INFOMSGS when running checkdb to …
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 than spending hours clicking through the SSMS dialogs to add those users I decided to script it out. The requirement was the given a list of usernames and passwords the user be added as a …
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 I had a project where I needed to add a number of logins as SQL Server sysadmin users to several SQL Server instances. Rather than spending hours clicking through the SSMS dialogs … Latest 100 …
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 type of corruption in the database. Every time they ran a backup of the database there was an error #824 thrown into the SQL log and into the job failure message. When running CheckDB the …
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 repair corrupt databases and to provide options to running REPAIR_ALLOW_DATA_LOSS. Today the lessons from the corruption challenge are just as valid as they were in 2015, it is a good place to start if you …
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 smaller offerings that we have is for what we call our mentoring packages. The mentoring works like this. Client prepays for a block of hours, usually 4 to 6 hours up front. Client sends requests …
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 as: A full backup and restore of a corrupt database may help fix the corruption. This is FALSE. If the database is not so corrupt that backups are failing, the full back up a database, …