Discussions specific to the VMware vSphere hypervisor
Post Reply
john.wood
Service Provider
Posts: 21
Liked: 2 times
Joined: Nov 21, 2016 10:00 pm
Contact:

Restore SQL trn files from guest processing

Post by john.wood » May 24, 2017 5:05 am

Hi,

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?

regards,

John.
VMCE

Mike Resseler
Product Manager
Posts: 5740
Liked: 612 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Restore SQL trn files from guest processing

Post by Mike Resseler » May 24, 2017 5:36 am

Hi John,

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?

Mike

john.wood
Service Provider
Posts: 21
Liked: 2 times
Joined: Nov 21, 2016 10:00 pm
Contact:

Re: Restore SQL trn files from guest processing

Post by john.wood » May 24, 2017 8:58 am

Thanks Mike.
Mike Resseler wrote: What is the reason that your DBA's don't want to use the Explorer or Enterprise Manager to do the restore?
Because they're DBA's. :roll:

No offence to any DBA's that do see the value of using the Explorer or Ent Manager.
They want their cake and to eat it too.
VMCE

Mike Resseler
Product Manager
Posts: 5740
Liked: 612 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Restore SQL trn files from guest processing

Post by Mike Resseler » May 24, 2017 9:04 am

So if I understand correctly, they prefer to do everything through SQL server management studio itself? Or are they using any other tool

john.wood
Service Provider
Posts: 21
Liked: 2 times
Joined: Nov 21, 2016 10:00 pm
Contact:

Re: Restore SQL trn files from guest processing

Post by john.wood » May 24, 2017 10:24 am

SQL Management Studio.
VMCE

foggy
Veeam Software
Posts: 18278
Liked: 1564 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Restore SQL trn files from guest processing

Post by foggy » May 26, 2017 4:41 pm

Then they need to disable logs processing in Veeam B&R and use SQL Management Studio to backup logs.

Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests