Post reply

TRN Files

  • November 19, 2007 at 4:10 pm

    #184319

    Hi Guys,

    This is my first post. I'm trying to restore transaction logs. I have a list of TRN files.

    In Enterprise Manager when I try to restore the logs i'm getting and error

    XXXXX.TRN is not apart of a multiple family media set.

    I need to restore the logs and record the time. Any help would be appreciated.

    Thanks,

    Dave

  • November 20, 2007 at 7:46 am

    #752705

    No one???

  • November 20, 2007 at 7:54 am

    #752710

    Are you adding all the files at once under the restore "From Device" radio button?


    Nuke the site from orbit, its the only way to be sure... :w00t:

  • November 21, 2007 at 1:11 am

    #752969

    Dont forget to back up the tail of the log - you may need the latest transactions:)

  • November 21, 2007 at 4:28 am

    #753033

    have a look at

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1304311&SiteID=1

    I remember having this the first time that I tried to do a point in time restore from transaction log files, as I had added in all the transaction logs in the backup location dialog. I did them one at a time in the end.

    You could right a script to do the restores one at a time instead of using GUID.

    Julian

  • November 21, 2007 at 7:38 am

    #753104

    Thanks for all your help guys! I appreciate it very much

  • November 21, 2007 at 11:29 pm

    #753280

    You must start this process from the last full backup, remenber set the option to 'Restore with no recovery' This is the starting point. You must then apply each of the transaction logs in order, remembering to set the option to 'Restore with no recovery' until you reach the transaction log that should include the timeframe you require, remeber to set the "Stop at" time and select the "With Recovery" option for the last log restore.

    EasyPeasyLemonSqueezy.

    CodeOn:P

Viewing 7 posts - 1 through 6 (of 6 total)

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