How to generate the script to restore transaction log backup?

Question

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

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

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 1

You will have to add the scripting piece inline with the physical_device_name but shouldn't be too much work to get the syntax selected out;

selectbmf.physical_device_name

frombackupset bs join backupmediafamily bmf

on bs.media_set_id = bmf.media_set_id

wherebs.backup_start_date > getdate()-30

and physical_device_name like '%TestDatabase%'

and bs.type = 'L'

order by bs.backup_finish_date

...and you will need to change the date parameter to just get the ones you are looking for.

David

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Steve Jones - SSC Editor SSC Guru Points: 736101 More actions · Answer 2

There are lots of scripts on the site here. You might try searching for "restore log"