And an example corrupt 2000 database to play with

And an example corrupt 2000 database to play with

Rate This
  • Comments 4

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!

Leave a Comment
  • Please add 6 and 6 and type the answer here:
  • Post
  • Thanks Paul.

  • Thanks Paul...looking forward to digging deeper :)

  • Quick Links Security - Platforms - Internet - SQL Server - Exchange - Manageability Security News...

  • Have you ever wondered you can recover a corrupted database when you have optimum backup & restore

Page 1 of 1 (4 items)