reynolddejesus100 (5/26/2015)
i have a full backup followed by transaction log every Monday, Wednesday and Friday, how can i restore this file using sql agent to automate restoration of backup files with different file-name.thanks in advance!
As a bit of a sidebar, that leaves you wide open to possible data loss for a period of up to 48 hours on most days and 72 hours over the weekend. I strongly recommend you change your log backups to at least once per hour and, if your databases aren't monsters, that you do a full backup every night.
--Jeff Moden
Change is inevitable... Change for the better is not.