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, but I don’t. That’s part of making this more diabolical than the last challenge.
Download the corrupt database files here: CorruptionChallenge4.zip
When restoring, you may need to use the KEEP_CDC flag on your restore.
- Current Scores
- Newsletter Sign up
- Database Corruption Challenge T-Shirt
- Week 1, Week 2, Week 3
- Database Corruption Worksheet