SQL Log Backup

VMware specific discussions

SQL Log Backup

Veeam Logoby jluce » Wed May 20, 2015 4:56 pm

We are looking at performing SQL Log Backups of one of our SQL servers who is very busy. I wanted to be sure I have this correct.
1. We can choose which databases we want backed up by in this manner by simply putting a database in FULL Recovery Mode. Those not in Full Recovery Mode as backed up via VSS? I've read a bit and see the Enable DBExclusion mentioned in concert with the Log SHipping method. Am I confusing something here?
2. We use normally are backing up via Virtual Appliance mode (which happens to run on a separate VLAN), however those SQL logs will have to reach the Repository via the OS or a separate Log Shipment server, so it should be expected that once we enable SQL Log Backup that my normal traffic will increase based on the frequency of backup.
jluce
Enthusiast
 
Posts: 25
Liked: 3 times
Joined: Wed Jan 14, 2015 2:23 am
Full Name: John Luce

Re: SQL Log Backup

Veeam Logoby foggy » Thu May 21, 2015 4:01 pm

jluce wrote:1. We can choose which databases we want backed up by in this manner by simply putting a database in FULL Recovery Mode. Those not in Full Recovery Mode as backed up via VSS? I've read a bit and see the Enable DBExclusion mentioned in concert with the Log SHipping method. Am I confusing something here?

This registry value enables UI option that allows to entirely exclude databases from VSS processing.

jluce wrote:2. We use normally are backing up via Virtual Appliance mode (which happens to run on a separate VLAN), however those SQL logs will have to reach the Repository via the OS or a separate Log Shipment server, so it should be expected that once we enable SQL Log Backup that my normal traffic will increase based on the frequency of backup.

Logs can be shipped either via network or via VIX.
foggy
Veeam Software
 
Posts: 14765
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Log Backup

Veeam Logoby jluce » Thu May 21, 2015 4:48 pm

If I am reading this correctly then, SQL Log Backup is performed on those DBs that are in Full Recovery mode only on the SQL server being backed up? What happens to those databases that are not in Full Recovery mode?

Is there any way to force VIX shipping or does the system determine this on its own?

Thanks in Advance.
jluce
Enthusiast
 
Posts: 25
Liked: 3 times
Joined: Wed Jan 14, 2015 2:23 am
Full Name: John Luce

Re: SQL Log Backup

Veeam Logoby foggy » Fri May 22, 2015 12:15 pm

jluce wrote:If I am reading this correctly then, SQL Log Backup is performed on those DBs that are in Full Recovery mode only on the SQL server being backed up?

Correct.

jluce wrote:What happens to those databases that are not in Full Recovery mode?

Nothing, in terms of logs truncation (in Simple mode logs are managed by SQL server itself).

jluce wrote:Is there any way to force VIX shipping or does the system determine this on its own?

VIX is used (both for logs backup and entire VM backup) in case VM is not available on the network. There's a registry value that inverts that order.
foggy
Veeam Software
 
Posts: 14765
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Log Backup

Veeam Logoby jluce » Mon Jun 01, 2015 6:54 pm

Just one more question.. how do the logs in the Full Recovery Mode then get truncated then?
jluce
Enthusiast
 
Posts: 25
Liked: 3 times
Joined: Wed Jan 14, 2015 2:23 am
Full Name: John Luce

Re: SQL Log Backup

Veeam Logoby v.Eremin » Tue Jun 02, 2015 8:50 am

For the databases in Full Recovery mode the corresponding logs will be handled in accordance with the settings you specify. Thanks.
v.Eremin
Veeam Software
 
Posts: 13296
Liked: 974 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 22 guests