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.
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