Configuring Merge Replication
This video is a 12 minute demo of how to quickly configure merge replication and to see it in action between SQL Server 2019 and… Read More »Configuring Merge Replication
SQL Server Recovery Models Explained
SQL Server recovery models often incorrectly referred to as (MS SQL Recovery Mode) define how your SQL Server database will treat your transaction logs. There… Read More »SQL Server Recovery Models Explained
Ransomware on SQL Server
What does ransomware do to a SQL Server? Ransomware The way that ransomware generally does their thing it encrypts files and then leaves some clues… Read More »Ransomware on SQL Server
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… Read More »Weekly Summary – June 12, 2020
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… Read More »Does a corrupt database really need to be repaired?
What does it mean when a SQL Database is SUSPECT?
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?
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.… Read More »repair_rebuild vs repair_allow_data_loss
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… Read More »Do Not Run REPAIR_ALLOW_DATA_LOSS
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… Read More »Location of Master MDF files
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… Read More »CHECKDB WITH NO_INFOMSGS