I have a Publisher and 34 Subscribers with merge replication. One of the Server database was marked as Suspect. I reset the status and Set the database to Emergency Mode. When I ran DBCC, the following error message showed 'Table error: Allocation page (1:606600) has invalid PFS_PAGE page header values. Type is 0. Check type, alloc unit ID and page ID on the page.', I found one table corruption and I could not execute any query to retreive data from that table. What should I dno now? No back up is available for last one month.
Not really. If repair can't fix it and you have no backup, you are probably out of luck. You can try dropping/creating indexes etc, but I don't think that is gonna help here. Backups are a good thing, unfortunately, lesson learned the hard way.
If any of your subscribers has a full copy of your data (Or that table) you can backup a subscriber and try and retrieve the data from there.
SQL PFS_Page error.
Posted - 09/26/2012 : 12:04:35
