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 recommend the SQL Server 2014 12.0.2000.8 version since this is the SQL Server 14 RTM (Release to Manufacturing) version.
Microsoft SQL Server 2014 – 12.0.2000.8 Corruption Challenge #5
Microsoft SQL Server 2012 (SP1) – 11.0.3128.0 Corruption Challenge #5
Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 Corruption Challenge #5
Related Links
- Current Scores
- Newsletter Sign up
- Database Corruption Challenge T-Shirt
- Week 1, Week 2, Week 3, Week 4
- Database Corruption Worksheet
Getting Help from Steve and the Team
Contact us for your Free 30 minute consultation ORschedule your appointment now.