Post reply

Applying LDF transactions to restored Backup

  • May 26, 2007 at 2:24 am

    #116977

    I have a good database backup which is a day old. The disk crashed which held the MDF data file but I still have the LDf files  intact on another disk. I have restored my backup succesfully, but is there anyway that I can get yesterday transactions from the LDF files which are intact applied to the  current restored 1 day old database? 

  • May 27, 2007 at 10:01 am

    #709134

    According to the BOL, when you run RESTORE DATABASE using the NORECOVERY option, it will not roll back any uncommitted transactions and permit you to run a RESTORE LOG to apply the transaction log. It think that's what you need to do.

    The database remains in the "restoring" mode and is unusable until you restore the transaction log, but this time using the RECOVERY option. After that, the database is ready for use.

    PS - If you don't specify that argument, the default is RECOVERY.

    Check the BOL for a more complete explanation.

    Hope that helps.

     

  • May 27, 2007 at 11:19 pm

    #709155

    Yes you may be able to recover some of the transactions in the LDF file. What you need to do is perform a "Tail Log" backup. Refer to this KB for details,

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;253817

    --------------------
    Colt 45 - the original point and click interface

  • May 28, 2007 at 5:13 am

    #709179

    Thanks for the replies. I could use the info

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

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