May 17, 2010 at 12:21 pm
Early last week experienced NTFS corruption which resulted in a couple of torn pages as evidenced by DBCC checkdb. I have the tried page level restores without success since a vendor tried to take a tail end Tlog backup and never took the system offline. End result the transaction log chain is broken so we can't restore using a post corruption backup.
But my actual question is this, I have the two pages in question can I determine the database objects that rest on those pages. The database contains one table with two columns(unique ID, TEXT).
May 21, 2010 at 11:36 am
Chris Mathews (5/17/2010)
But my actual question is this, I have the two pages in question can I determine the database objects that rest on those pages. The database contains one table with two columns(unique ID, TEXT).
Only if you can read the headers of those pages and the headers are intact. Depends on how bad the damage is.
Try
DBCC TRACEON(3604)
DBCC Page(<database id>, <file id>, <Page Number>
DBCC TRACEOFF(3604)
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
May 21, 2010 at 11:46 am
Thanks, we created a new blank database and copied all the good records across (2 bad records) and caught the offending records object IDs in a try..catch loop.
Now that we have those IDs in a separate table, we restored to a known good backup and insert..select from to copy those records in the new database.
Voila.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply