Restore of transaction logs

• GF

  Hall of Fame

  Points: 3774

  More actions

  October 15, 2004 at 8:10 pm

  #108941

  I backup my transaction logs to a different server. I back up my logs every 30 min so I have a large number of them through out a 24 hour period.

  I can restore the logs one at a time through enterprise manager but I want to speed up the process.

  I have tried this from books online but it does not work.

  RESTORE LOG MyDatabase

     FROM Mytranslog.trn

     WITH NORECOVERY

  I keep getting an error Line 2: "Incorrect syntax near '.'

  would someone be so kind as to show me a way to restore more than 1 transaction log at a time?

  I realize the above code would be repeated for each transaction log I want to restore.

   

  thanks

  Gary

• Ray Mond

  SSCertifiable

  Points: 7159

  More actions

  October 16, 2004 at 10:07 am

  #526977

  RESTORE LOG MyDatabase FROM DISK = 'Mytranslog.trn' WITH NORECOVERY

  SQL BAK Explorer - read SQL Server backup file details without SQL Server.
  Supports backup files created with SQL Server 2005 up to SQL Server 2017.

• Don Millhouse

  SSC Eights!

  Points: 977

  More actions

  October 17, 2004 at 8:31 pm

  #526999

  If you append to your transaction log backup file you will also need to use the FILE= argument.

  I have done this and programatically incremented the file number to restore multiple log backups.