This week you are given a zip file with 5 files in it. A Full Backup of the database before the corruption occurred, a text file describing the exact version this was tested on. The mdf, ldf, and ndf files for the database that were copied after the “Recovery Pending” message was discovered. Download the corrupt database files here: I …
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 …
There is a lot happening right now, so I thought I would put together a brief overview of upcoming speaking engagements. May 13th – When Corruption Strikes (PASS DBA Virtual Chapter Meeting) May 16th – Exploring SQL Server Join Types – INNER, OUTER, and much more… (SQL Saturday Redmond) June 9th – When Corruption Strikes 2 (HADR Virtual Pass Chapter) June …
Today is the release of Database Health Monitor Beta 10.1. If you haven’t see the Database Health Monitor before, its a free application that I have been building over last 4 years. It has been a while since the last release, so I thought I would just walk through and show a few of the features. One thing that changed right …
Database Health Monitor -Beta Version 10.1 Released Today Read more »
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 …
SPOILER ALERT…. Page down, if you would like to read the clue, however if you want to proceed without the clue stop reading here. Page down, if you would like to read the clue, however if you want to proceed without the clue stop reading here. Week 4 is proving to be more challenging than previous weeks. So …
Database Corruption Challenge #4 started about 20 minutes late today due to an upload problem. The corrupt database file is zipped to 22mb, however wordpress (where my site is hosted) would not let me upload anything bigger than 8mb. After a quick panic, I uploaded the file to a different wordpress site, where Database Health Monitor is hosted, and had no …
Technical details getting started with the challenge this week. Read more »
What you are given: The full backup file after the corruption occurred. That’s it this week, let’s just say this database didn’t have the best backup and restore schedule in place. There is one backup file, a full backup containing the corruption. I wish I had some transaction logs, and I wish I had a backup from before the corruption, …
The database name is [CorruptionChallenge4], it was created and backed up on SQL Server 2008R2. Sorry, no SQL Server 2005 this week due to features in the challenge that didn’t exist in SQL Server 2005 (perhaps that a hint). Here is what we know. Everything was just fine, and all of a sudden users started reporting the following error …
Do you need some help with your SQL Server, but perhaps don’t need another full time DBA? Do you need some help to cover your DBA being out on vacation? Do you need help assessing the health of your SQL Servers, and determining which need work? Do you know if you can recover in the event of database corruption or …