Post reply

How to restore multiple TRN (log) files at a time?

  • October 26, 2006 at 10:27 am

    #153258

    Hi,

    Need help in restoring log (.TRN) files.

    I have one .bak file and around 50 .TRN files (time difference is 15 mins).  First I need to restore bak file and restore TRN files one by one.  This is really eating up my time, every time I need to write TRN file and click on execute button.

    I am really frustrated in doing this.  Is there any other way to restore them with a single script?

    Thanks in advance.

    Mahesh

  • October 26, 2006 at 12:37 pm

    #668328

    You can create differentials and it can reduce the amount of time it takes to restore quite a bit


    * Noel

  • October 26, 2006 at 12:45 pm

    #668331

    Here's a link to a script that I use to generate the restore commands I need. It's much faster than using the GUI.

    http://qa.sqlservercentral.com/scripts/viewscript.asp?scriptid=1505

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

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