Recently when I needed to find the Transaction Log file that can be applied to a log shipping secondary database I decided to take a few moments and automate the process that I usually do in the old fashion manual way and that includes: 1. generating the restore log commands using a query over backupset …

Find the specific sql server t-log to be restored for an unrecovered database Read More »