by john.wood » Wed May 24, 2017 5:05 am people like this post
I've setup a backup job for MS SQL with guest processing for application aware log shipping every 15mins with truncation.
Enviroment: Veeam 9.5 U1 SQL 2014 Windows 2012 R2
I've been requested by our DBA's if it is possible to be able to restore the logs as TRN files only and not use the explorer to restore directly to the database.
I've trawled through the event viewer logs to find the location where Veeam puts the logs before taking a backup and removing them, but have not found them in an image backup. Is there a way to restore the TRN files as a file level restore?
by Mike Resseler » Wed May 24, 2017 5:36 am people like this post
We store the logs as VLB files on the repository (same repository as where you are saving the image-level backup). As far as I am aware, there is no possibility to extract the log files from there directly besides using the Veeam explorer.
What is the reason that your DBA's don't want to use the Explorer or Enterprise Manager to do the restore?