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 last known good database. Shut down the database, and copy off the last good database files. Replace some files and …
The database name is [CorruptionChallenge5], it was created and backed up on one of the specific versions of SQL Server listed here. Be sure that you get a version to match your SQL Server. Sorry I don’t have any 2005 or 2008 support this time, and there isn’t support for every minor version. Microsoft SQL Server 2014 – 12.0.2000.8 Microsoft …
On Wednesday May 13th I will be presenting to the PASS DBA Virtual Chapter Meeting, at Noon Mountain time (convert to your time zone). The session is titled “When Database Corruption Strikes“, and the event has been sponsored by Dell Software Abstract: You are working along month after month with no problems in your database. Suddenly someone reports that their query …
When Corruption Strikes – Online Presentation Wed May 13th Read more »
Here is the solution provided by Patrick Flynn. Congratulations Patrick for being one of this weeks winners. I really liked this solution for a number of reasons, first it showed how to pull data from DBCC Page and actually convert it into rows and columns that could then be inserted back into a table. Secondly due to its use of …
Congratulations to Randolph West who won the corruption challenge this week with the following solution which restored all of the data. First he restored the database to get started. Note some of his code and comments have been reformatted to better fit in the blog format. Restore database. I use KEEP_CDC and KEEP_REPLICATION because of the hints you dropped in …
Corruption Challenge Week 4 – The Winning Solution Read more »
It is my pleasure to announce the winners in the Week 4 Database Corruption Challenge. But first how about a rundown of challenge. In order to make up for the difficult time that Challenge #3 was issued, Challenge #4 was issued at 2:00pm pacific time on a Friday afternoon. Those who had signed up for my Newsletter received early notification of …
The following are the steps that I went through to create a more difficult Database Corruption Challenge for Week 4. Here is how I built the database, nothing fancy, however I did add an extra FILEGROUP called [UserObjects]. Notice, that to make things slightly more challenging, the database is a Case Sensitive Accent Sensitive database. I hope this didn’t cause …
Welcome to the Week 4 Corruption Challenge. If you have seen the t-shirt that I designed for the winner at the end of the 10 week period, please take a look. This challenge is more diabolical than previous weeks, at least it was more difficult to build than I had planned for. If I wasn’t out of work this …
The Bellingham SQL Server Users Group will be having its next meeting on May 20th at 6:00pm. This is free event for the local SQL Server community. What is the Bellingham SQL Server Users Group? PASS Chapters are local user groups that meet regularly in communities around the world to share their passion and knowledge about Microsoft SQL Server and …
Yesterday I blogged about submitting to SQL Saturday Denver, which is about 5 months away, after writing that post, I realized that I haven’t even blogged about SQL Saturday Redmond which is occurring in just over 2 weeks. SQL Saturday #393 Redmond marks just 3 years since my first time speaking at a SQL Saturday #108 in Redmond. So lets …