Host-based backup of VMware vSphere VMs.
Post Reply
claudiofolu
Enthusiast
Posts: 78
Liked: 4 times
Joined: Jan 12, 2012 3:45 am
Full Name: claudiofolu
Contact:

SQL transactional log backup

Post by claudiofolu »

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
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: SQL transactional log backup

Post by Shestakov »

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: 78
Liked: 4 times
Joined: Jan 12, 2012 3:45 am
Full Name: claudiofolu
Contact:

Re: SQL transactional log backup

Post by claudiofolu »

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: 20283
Liked: 2258 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL transactional log backup

Post by veremin »

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

Who is online

Users browsing this forum: chris.mcdonald and 45 guests