Attach database throws error "Could not redo log record (62704:2232:11), for transaction ID (0:0), on page (1:304)"

  • I am trying to attach a database and get the following error:
    Could not redo log record (62704:2232:11), for transaction ID (0:0), on page (1:304)
    Before you ask, I do not have a recent backup. Is there a way to isolate the offending record and remove it so the attach can complete?

    Thanks!

  • I think your best bet is to follow something like this:
    https://stackoverflow.com/questions/38995380/sql-server-how-to-attach-repair-a-detached-damaged-database

    In the answer, steps 1 through 4 will get the database online but you will be missing transactions.  Steps 5 onward are to try to recover those transactions.
    Prior to step 4 though, I'd make sure you have a copy of the damaged database.
    I would recommend keeping the database in some flavor of single user mode so others don't go in and muck up the data.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply