SQL transactional log backup

VMware specific discussions

SQL transactional log backup

Veeam Logoby claudiofolu » Wed 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
claudiofolu
Enthusiast
 
Posts: 42
Liked: 1 time
Joined: Thu Jan 12, 2012 3:45 am
Full Name: claudiofolu

Re: SQL transactional log backup

Veeam Logoby Shestakov » Wed 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!
Shestakov
Veeam Software
 
Posts: 4861
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: SQL transactional log backup

Veeam Logoby claudiofolu » Wed 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.
claudiofolu
Enthusiast
 
Posts: 42
Liked: 1 time
Joined: Thu Jan 12, 2012 3:45 am
Full Name: claudiofolu

Re: SQL transactional log backup

Veeam Logoby v.Eremin » Thu Jun 25, 2015 9:06 am

Just try to search given directory or volume, using native OS capabilities (*.vlb mask). Thanks.
v.Eremin
Veeam Software
 
Posts: 13281
Liked: 970 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 23 guests