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?June 11, 2020 At Stedman Solutions, LLC the team and I do many database …
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 a shutdown. For instance, if the power was unplugged from the SQL Server while shutting …
What does it mean when a SQL Database is SUSPECT? Read more »
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 …
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 …
Part of good server monitoring it to have alerts enabled for a number of different errors to know when things go bad. The problem is we were getting the following error every time the server was restarted. SQL Server Alert …
I received a contact message from the “Contact us” form, asking about how to go about repairing corruption in TempDB. The error message was something like this: SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:118576; actual …
One of those services that I offer is on call help for DBA’s who encounter database corruption. Call me anytime 24/7 and as long as you are an existing customer, or we can work out a billing arrangement to …
Database Corruption Overview: Database corruption is one of those things that you can only plan for by practicing your response plan. Out of all of the things that can happen to your SQL Server this is the one that you …
With the updated release of Database Health Monitor yesterday, here is the updated list of documentation on the Quick Scan Report. All of the following (plus a few more) are checked from the Database Health Monitor Quick Scan report. The …
Today I have the pleasure of releasing the next version of the Database Health Monitor application. Currently at version 2.2, I have been working on this since 2011, and I have introduced some new features in the latest version. Visit …