Discussions specific to the VMware vSphere hypervisor
Post Reply
claudiofolu
Enthusiast
Posts: 50
Liked: 2 times
Joined: Jan 12, 2012 3:45 am
Full Name: claudiofolu
Contact:

SQL transactional log backup

Post by claudiofolu » Jun 24, 2015 5:09 pm

Hello,
Anybody knows where Veeam keeps the transactional logs backup when you select to "Backup logs periodically" ?

Documentation says that Veeam saves them in files of VBL format next to VM image-level backup, but I can´t find them.

Thank you

Shestakov
Veeam Software
Posts: 6974
Liked: 715 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: SQL transactional log backup

Post by Shestakov » Jun 24, 2015 5:40 pm

Hello claudiofolu,
You are correct, the logs are stored as .vlb(s) should be with the corresponding SQL Server VM backups in the repository folder (by default, \Backup\<SQL_server_VM_backup_job_name>).
Note that the retention policy of logs can differ from VM backups. Are we talking about backup job? Since logs can not be moved by backup copy or tape jobs. Thanks!

claudiofolu
Enthusiast
Posts: 50
Liked: 2 times
Joined: Jan 12, 2012 3:45 am
Full Name: claudiofolu
Contact:

Re: SQL transactional log backup

Post by claudiofolu » Jun 24, 2015 6:05 pm

Thank you for your answer.
It´s a backup job, no copy or tape jobs related.
Backup job have been running since a couple days now, and transactional logs backup every 60 minutes.
Strange thing is that I can´t find those .vbl files, and when I try to do a restore, I can select to any point in time, so transactional logs are present in the backup.

veremin
Product Manager
Posts: 16908
Liked: 1440 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL transactional log backup

Post by veremin » Jun 25, 2015 9:06 am

Just try to search given directory or volume, using native OS capabilities (*.vlb mask). Thanks.

Post Reply

Who is online

Users browsing this forum: amccloud, Egor Yakovlev, kapple, mnpezzali, Senchoz, Vitaliy S. and 41 guests