Restore SQL trn files from guest processing

VMware specific discussions

Restore SQL trn files from guest processing

Veeam Logoby john.wood » Wed 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
john.wood
Service Provider
 
Posts: 21
Liked: 1 time
Joined: Mon Nov 21, 2016 10:00 pm

Re: Restore SQL trn files from guest processing

Veeam Logoby Mike Resseler » Wed 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
Mike Resseler
Veeam Software
 
Posts: 3151
Liked: 362 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Restore SQL trn files from guest processing

Veeam Logoby john.wood » Wed 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
john.wood
Service Provider
 
Posts: 21
Liked: 1 time
Joined: Mon Nov 21, 2016 10:00 pm

Re: Restore SQL trn files from guest processing

Veeam Logoby Mike Resseler » Wed 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
Mike Resseler
Veeam Software
 
Posts: 3151
Liked: 362 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Restore SQL trn files from guest processing

Veeam Logoby john.wood » Wed May 24, 2017 10:24 am

SQL Management Studio.
VMCE
john.wood
Service Provider
 
Posts: 21
Liked: 1 time
Joined: Mon Nov 21, 2016 10:00 pm

Re: Restore SQL trn files from guest processing

Veeam Logoby foggy » Fri 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.
foggy
Veeam Software
 
Posts: 14742
Liked: 1080 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 7 guests