And an example corrupt 2000 database to play with
As promised in my earlier post of an example corrupt 2005 database, here's one I've just created for SQL Server 2000.
The attached WinZip file contains a backup of a simple 2000 database called 'broken' . It has a simple table called 'brokentable' (c1 int, c2 varchar(7000)) with one row in it. The table has a single data page with page ID (1:75) that I've corrupted so the page header is corrupt. When you try selecting from the table, you should get a 605 error that kills the connection. See the previous post for instructions on restoring it etc.
Have fun!
Comments
Anonymous
April 22, 2007
Thanks Paul.Anonymous
April 26, 2007
Thanks Paul...looking forward to digging deeper :)Anonymous
April 30, 2007
Quick Links Security - Platforms - Internet - SQL Server - Exchange - Manageability Security News...Anonymous
May 05, 2007
Have you ever wondered you can recover a corrupted database when you have optimum backup & restore