Welcome to the eighth week of 10 in the Database Corruption Challenge (DBCC), this is an about weekly competition. Here is how it works; I have created a corrupt database, hopefully more corrupt or more interesting than the previous week. I then solved the corruption myself in order to prove that it is possible to fix, without data loss. There is …
Database Corruption Challenge #8 will be starting at 6:00pm today (Friday June 19th). Check back soon for the details. Are you feeling corrupt? -Steve Stedman
Lately several people have asked me for the solutions to the corruption challenge, so I thought it would be a good time to recap the last 7 weeks. Week 1 of the Database Corruption Challenge was won by Brent Ozar, his solution is posted here. Also there is an alternate solution provided by Andre Kamman. Week 2 of the Database Corruption …
Today I am presenting to the session “When Database Corruption Strikes” to the High Availability and Disaster Recovery PASS Virtual Chapter. Here is the abstract: You are working along month after month with no problems in your database. Suddenly someone reports that their query won’t run. They get an error stating “SQL Server detected a logical consistency-based I/O error“, or …
The alternate solution to the Database Corruption Challenge this week was created by Patrick Flynn. This solution is the only solution to successfully recover all the data without using any of the backups. If the challenge had been structured differently and all you had was just the database files and no backups, this solution would work just fine. As you …
Database Corruption Challenge Week 7 – Alternate Solution Read more »
How do you check if a database exists, drop it and recreate it for testing purposes? After running the Database Corruption Challenge for several weeks now, I have seen many scripts to drop and recreate a database. This makes it clear that it takes many tries to get the corruption challenge right. They usually start out with something like the …
The seventh week of ten in the Database Corruption Challenge went well. There were a few new participants, and many of those who have competed week over week. The first to submit a correct answer this week was Raul Gonzalez. What was interesting about this challenge was that it was not your typical corruption where you could just run DBCC CheckDB and …
It has been a long day, but I was able to get the latest Beta release of Database Health Monitor out. If you haven’t heard of Database Health Monitor monitor before, here is the quick rundown. It is a set of performance monitoring reports and tools to help you get more performance out of your SQL Server. Database Health Monitor is a project that …
Database Health Monitor Beta 10.2 Released Today Read more »
Welcome to the seventh week of 10 in the Database Corruption Challenge (DBCC), this is an about weekly competition. Here is how it works; I have created a corrupt database, hopefully more corrupt or more interesting than the previous week. I then solved the corruption myself in order to prove that it is possible to fix, without data loss. New …
I was asked recently how to move TempDB on SQL Server. The question specifically was how to move the TempDB files to different drives. At that point I realized that I don’t have that posted to my blog, so here we go. You may have a specific reason to move your TempDB to faster drives. There may be any number of other …