detaching database results in error "SQL Server detected a logical consistency-based I/O error"
Torn page usually. Do you have backups? DBCC may be able to fix it though

The king of DBCC is Paul Randal: to avoid my copy/paste, read these from him


SQL Server 2008: Automatic Page Repair with Database Mirroring
Whitepaper


And search his site too for "logical consistency"