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 …
At Stedman Solutions, LLC, we recently had the opportunity to help out another client with a corrupt database, to completely recover all their data and remove all the corruption. In this specific scenario Microsoft had told them that their only …
Please join me on Saturday March 16 in Victoria BC Canada for my SQL Saturday presentation on the Basics of Database Corruption Repair. Here is the session, the Basics of Database Corruption Repair. Duration: 60 minutesTrack: AdminLevel: Intermediate Your database …
Recently Derrick and I had a chance to help with a corruption repair in Thailand, just to clarify, the client was in Thailand, not us. This was our second corruption of the year this year. Here is what the client …
Hello everyone, the last week I have not been able to keep everyone as up to date on the Database Corruption Challenge as I would like to. Life has just turned really busy in the last 10 days, but I …
Here is how I solved Week 5 of the Database Corruption Challenge. The following steps were tested and confirmed working on SQL Server 2008R2, SQL Server 2012, and SQL Server 2014. To oversimplify, here are the steps: Restore the …
Find out more about the Week 5 Challenge on the overview blog post. The winning solution, was submitted by Patrick Flynn, just 3 hours and 18 minutes after the challenge was posted. Patrick provided me with the following steps, and TSQL …
Week 5 – Winning Solution – Database Corruption Challenge Read more »
As the weekend approaches and we head for another Database Corruption Challenge (DBCC) I want to remind everyone who is interested of being notified of the next event to sign up for my newsletter. Just click here to find out …