Fixing a corrupt database
Database corruption issues are usually signaled by, “Torn Page” errors. These are nearly always caused by I/O subsystems – meaning disk drives, NAS storage or RAID arrays/cards. The video available from the link below is an excellent summary of database corruption and repair by the engineer who actually wrote the CHECKDB command for SQL Server 2005 (Paul Randal).