Tag: stevestedman

Database Corruption Week 7 Solution http://stevestedman.com/server-health/database-corruption-challenge/week-7-database-corruption-challenge/week-7-challenge-details/

Database Corruption Week 6 Solution http://stevestedman.com/server-health/database-corruption-challenge/week-6-database-corruption-challenge/week-6-challenge-details/ Check for corruption in the database, isolate to non clustered index. Keep changes that will be lost when repairing damage. In this case there are 2 row first name values that “look” to be incorrect in the cluster. Write two simple updates to be run following disable and rebuild of…

Database Corruption Week 5 This week I managed to achieve the goal, however it was not very elegant. Plus the only way I could achieve it was to use a hex editor. Basically I copied page 9 from the backup, and replaced it in the live version with an editor, which then enabled access to the…

Database Corruption Week 4 Solution Here is my late solution for week four. Blame the UK Bank Holiday. The original database and details for this can be found here: http://stevestedman.com/server-health/database-corruption-challenge/week-4-database-corruption-challenge/week-4-challenge-details/ This week was harder, but easier with the clue provided pointing you towards the right area.

Database Corruption Week 3 Solution Here is the solution for week three. The original database and details for this can be found here: http://stevestedman.com/server-health/database-corruption-challenge/week-3-database-corruption-challenge/week-3-challenge-details/ This week was kind of easy as all that is needed is to backup the transaction log with NO_TRUNCATE, and then follow a standard restore. If for some reason the database had been…

Database Corruption Week 2 Solution Unfortunately I missed week 2 submissions, but here is my solution for week two. The original database and details for this can be found here: http://stevestedman.com/server-health/database-corruption-challenge/week-2-database-corruption-challenge/week-2-challenge-details/   The data corruption is confined to a single page. Page 244. There is a non clustered index available meaning that the only columns that are…

Database Corruption Week 1 Solution Here is my solution for week one. The original database and details for this can be found here: http://stevestedman.com/2015/04/introducing-the-database-corruption-challenge-dbcc-week-1-challenge/