-
- Enthusiast
- Posts: 25
- Liked: 3 times
- Joined: Jan 14, 2015 2:23 am
- Full Name: John Luce
- Contact:
SQL Log Backup
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.
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.
-
- Veeam Software
- Posts: 21069
- Liked: 2115 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SQL Log Backup
This registry value enables UI option that allows to entirely exclude databases from VSS processing.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?
Logs can be shipped either via network or via VIX.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.
-
- Enthusiast
- Posts: 25
- Liked: 3 times
- Joined: Jan 14, 2015 2:23 am
- Full Name: John Luce
- Contact:
Re: SQL Log Backup
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.
Is there any way to force VIX shipping or does the system determine this on its own?
Thanks in Advance.
-
- Veeam Software
- Posts: 21069
- Liked: 2115 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SQL Log Backup
Correct.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?
Nothing, in terms of logs truncation (in Simple mode logs are managed by SQL server itself).jluce wrote:What happens to those databases that are not in Full Recovery mode?
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.jluce wrote:Is there any way to force VIX shipping or does the system determine this on its own?
-
- Enthusiast
- Posts: 25
- Liked: 3 times
- Joined: Jan 14, 2015 2:23 am
- Full Name: John Luce
- Contact:
Re: SQL Log Backup
Just one more question.. how do the logs in the Full Recovery Mode then get truncated then?
-
- Product Manager
- Posts: 20270
- Liked: 2252 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: SQL Log Backup
For the databases in Full Recovery mode the corresponding logs will be handled in accordance with the settings you specify. Thanks.
Who is online
Users browsing this forum: No registered users and 83 guests