I was looking through my SQL Server error logs to confirm that CheckDB was being run as I had scheduled based on my previous post to run DBCC CheckDB on all databases. I wanted to confirm that there was no corruption, and that all of the databases had been checked, and not had been missed. Going through this I noticed …
As a DBA you regularly schedule backups you might have regular full backups, incremental backups and hopefully regular backups. Over time you might realize that your error log is not longer filled with errors, but instead a majority of your error log is filled with backup messages. “Backup Database successfully … “, “Database backed up…”, “Log was backed up”. This …
Database corruption repair with SQL Server is one of those things that you generally don’t see every day, but as a DBA, you are expected to be able to fix it quickly without any data loss. From the risk analysis matrix, it is one of those low frequency high impact scenarios that results in an extremely risky situation. This is one …
SQL Server Performance Tuning Tips – Wait Statistics Wait statistics are commonly overlooked ways to quickly find out what is causing your SQL Server to be slow. One of the reasons is it’s difficult to see how they are trending over time. >>> It is not difficult with a monitoring tool. <<< When someone reports a slow database yesterday at …
If you are looking for more info on the corrupt database with Week 10 of the Database Corruption Challenge, you can take a look at the week 10 Challenge Details. With this being the final competition of the Database Corruption Challenge, I had to make it more difficult than the others, so I added 3 different types of corruption. This challenge was …
Solution to Week 10 Part 1 Database Corruption Challenge Read more »
After 10 weeks (or almost weekly) of corrupt databases, missing data and a challenging competition the Database Corruption Challenge finally comes to an end. As part of the last week of the challenge I created a short blog interview for the participants. This interview is Patrick Flynn. Patrick placed in third with a 3 way tie for third overall in the the Database Corruption Challenge scoring 21 …
Patrick Flynn Interview – Database Corruption Challenge Read more »
Today I am proud to announce that the Database Corruption Challenge has come to an end. I would like to say that I have met some really great people during this contest and I look forward to seeing you at PASS Summit in October, or other conference someday. The Corruption Challenge Winners After 10 competitions Rob Farley is the overall Champion …
Announcing the Database Corruption Challenge Winners Read more »
Week 10 Database Corruption Challenge specific details Timeline of events leading up to this database needing help: Date and times on the files are for July 14th 2015. At about 4:50pm you get an email from a developer reporting that when they query the orders table that it appears to have a lot more rows in it than they were expecting. They …
I was asked how I caused the corruption in Database Corruption Challenge #9. Here is how I did it. To cause the corruption, I used the undocumented DBCC WritePage, however the same thing could have been accomplished by detaching the database, opening it with a hex editor, and then re-attaching the db. DBCC WritePage WARNING: DBCC WritePage is a dangerous …
Database Corruption Challenge #9 – How I Corrupted the Database. Read more »
Database Corruption Challenge #9 has completed with 19 winning participants, you can take a look at the scoring page for exact details. The first to solve the challenge this week was Eduardo Rezende who provided the winning solution just 58 minutes after the challenge began. The second winning solution arrived less than a minute after the first, so it was a …