Recover the corupt databases with the features in backup & restore - SQL Server 2005
Have you ever wondered you can recover a corrupted database when you have optimum backup & restore strategy in place, well I'm not talking about usage of third party tools or use high-end hardware. With simple backup and restore features in SQL Server 2005 for the databases you can recover the data effectively.
SQL Storage engine team has provided an example link blog here that can help you to understand what best you can achieve from them. But don't forget to keep the backup and restore intact within your environment, do not assume by performing backup would save your data. No backup is safe unless it is tested (restore) on another server that will provide a standby server approach within your enviornment.
The blog referred above 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:143) that I've corrupted so the page checksum is corrupt. You can try all sorts of things with this – there are many examples in the linked web page.
Another blog link for SQL 2000 version databases.