Torn Page Recovery
Posted on 2010-11-10
We recently had to recover a SBS 2003 from an outdate system partition backup, and unfortunately the SQL instances on the unit seem to have suffered fairly badly in the ordeal. MSDB for the default system SQL instance was beyond recovery and I was able to get that resolved nicely and quickly via a question on this site. Now when I try to start the instance the following error shows up in the application logs : SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0xaaaaaaa9). It occurred during a read of page (1:74) in database ID 5 at offset 0x00000000094000 in file 'D:\Pfx Engagement\Admin\Data\Admin_Data.MDF'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB).
To further complicate matters, there are two SQL instances that appear to be related to this ProFX Engagement software the end user is having issues with (due to the DB problems). I can post a screenshot of what SQL EM shows for instances if that last bit isn't clear.