Bhuvnesh (1/14/2013)
see the link http://jeffprom.wordpress.com/2008/08/22/fixing-torn-page-headers/
The solution he gave there is the absolute last resort for when there's no backup and checkDB can't repair the error. Furthermore, you should never detach a corrupt or suspect database (as he recommends) as there's a chance that the DB won't attach again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability