Feature Request - SQL Log Backups

Availability for the Always-On Enterprise

Re: Feature Request - SQL Log Backups

Veeam Logoby CPCS » Wed Jul 20, 2016 10:21 am

I dont have the C:\ProgramData\Veeam\Backup\SqlLogBackup Folder on my SQL Server which is backuped? oO
Instead there is an empty Oracle folder?! oO
CPCS
Influencer
 
Posts: 11
Liked: 3 times
Joined: Tue Mar 01, 2016 1:49 pm

Re: Feature Request - SQL Log Backups

Veeam Logoby foggy » Wed Jul 20, 2016 12:54 pm

foggy
Veeam Software
 
Posts: 14752
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

[MERGED] Veeam SQLServer Log Backup for large log volumes

Veeam Logoby Buh95 » Mon Nov 14, 2016 1:05 pm

Hi all,

We're studying the impact of migrating a big SQLServer (ERP/High transactional profile) from a physical server to a virtual one (Several TB of databases).

We've been happy Veeam users for years now, and we are already using Veeam to backup some small SQLServer Vmware VM, with periodic log backup (every hour).

All is working perfectly, but in case of our big sqlserver, I would have somme reserves, regarding the capacity of veeam to backup huge amount of logs.

In Veeam, the process of log backup uses a temporary local disk space to copy log files, before sending them to the veeam proxy server.
Today, we configure this temporary local disk space to redirect to another local disk (SQLTempLogPath in registry).

Our big sqlserver is able to generate between 1GB and 30GB per hour (in normal condition), and even 100GB/200GB of logs when DBA launch special REORGANIZE index operations...

So what would happen to my Veeam Log Backup :
=> Several long minutes to duplicate locally all the logs
=> and others several long minutes to send them by the network to the veeam server.

Does someone already experiment such a case in production ?
Do you know if there is a way to bypass the local log copy ?

Thanks in advance for your help.
Buh95
Influencer
 
Posts: 14
Liked: 3 times
Joined: Tue Nov 17, 2015 1:31 pm
Full Name: H.Schema.

Re: Feature Request - SQL Log Backups

Veeam Logoby foggy » Mon Nov 14, 2016 2:27 pm

Thanks for the feedback, currently there's no way to bypass the local copy of log files. You can find some thoughts on this above.
foggy
Veeam Software
 
Posts: 14752
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Previous

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Google [Bot] and 34 guests