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

• mamidimahesh-127681

  SSC Eights!

  Points: 868

  More actions

  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

• noeld

  SSC Guru

  Points: 96590

  More actions

  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

• ramses2nd

  Hall of Fame

  Points: 3720

  More actions

  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://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1505