• How to troubleshoot a Msg 823 error in SQL Server

    http://support.microsoft.com/kb/2015755

    To start, SQL Server 2008+ contains a system table called SUSPECT_PAGES that maintains information about suspect pages and their error states. This will help scope the problem and perhaps provide some history about other errors that led up to this event.

    http://msdn.microsoft.com/en-us/library/ms191301.aspx

    http://msdn.microsoft.com/en-us/library/ms174425.aspx

    You'll also want to run a consistency check on the disk storage system containing your database files. Rather than just data file corruption, your disk hardware in general may be failing.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho