VEB and MS SQL backup?

Backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)

VEB and MS SQL backup?

Veeam Logoby 4c7 » Mon May 04, 2015 2:49 pm

Hello, could you please clarify if I am right(the documentation on this one is pretty bad, at least the pieces I've found).
As far as I understood this product can only do windows VSS snapshots (no SQL VSS), so for MS SQL DB backup's I need to use some other method, right?
Or is there a way to do it with Endpoint Backup.

Thanks in advance.
4c7
Enthusiast
 
Posts: 47
Liked: 3 times
Joined: Mon May 04, 2015 2:45 pm
Full Name: 4c74356b41

Re: VEB and MS SQL backup?

Veeam Logoby Dima P. » Mon May 04, 2015 7:12 pm

Hello 4c7,
windows VSS snapshots (no SQL VSS)

Correct.
Dima P.
Veeam Software
 
Posts: 5843
Liked: 418 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB and MS SQL backup?

Veeam Logoby 4c7 » Mon May 04, 2015 7:54 pm

So there's no way to do it (SQL DB backup) with Endpoint Backup?
4c7
Enthusiast
 
Posts: 47
Liked: 3 times
Joined: Mon May 04, 2015 2:45 pm
Full Name: 4c74356b41

Re: VEB and MS SQL backup?

Veeam Logoby Mike Resseler » Tue May 05, 2015 10:57 am

Let me rephrase that a bit. We will make sure you have a consistent backup for your SQL server and data, however, what we don't do is truncate the logs so you will need to do that another way

Mike
Mike Resseler
Veeam Software
 
Posts: 2783
Liked: 342 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: VEB and MS SQL backup?

Veeam Logoby gmele » Fri May 15, 2015 12:24 pm

Hi,

on page 14 of the Veeam Endpoint Backup user's guide it says the following:

"[For Microsoft Windows Server Edition] If an application on the computer uses transaction logs to maintain the database consistency, Veeam Endpoint Backup automatically truncates transaction logs upon successful backup."

"Important! The Veeam Endpoint Service runs under the LocalSystem account. On Microsoft SQL Server 2012, this account does not have necessary permissions to truncate transaction logs. If you want Veeam Endpoint Backup to automatically truncate transaction logs, you need to manually add the LocalSystem account to a group that has the SQL Server System Administrator rights."

From what I read in the manual VEB should truncate transaction logs to "maintain database consistency". This may mean that it will do so for SQL Server but I haven't tested this...

Cheers,

Joe
gmele
Enthusiast
 
Posts: 26
Liked: never
Joined: Thu Apr 30, 2015 9:10 pm
Full Name: Mele Giuseppe

Re: VEB and MS SQL backup?

Veeam Logoby Mike Resseler » Fri May 15, 2015 12:43 pm

Hi Mele,

Actually, I did made a mistake on my previous response. SQL truncation does happen, it is Exchange that doesn't happen... Mixed those two up...
Sorry :-(

Mike
Mike Resseler
Veeam Software
 
Posts: 2783
Liked: 342 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: VEB and MS SQL backup?

Veeam Logoby mairiesuresnes » Wed May 20, 2015 8:56 am

A full backup of a SQL Server 2012 with Endpoint can be restored by attaching the .mdf and the .ldf, whereas an incremental backup of the same server doesn't allow one to attach a DB correctly (error with the trunsaction log)
mairiesuresnes
Enthusiast
 
Posts: 26
Liked: 2 times
Joined: Tue Apr 21, 2015 11:50 am
Full Name: Suresnes

Re: VEB and MS SQL backup?

Veeam Logoby Mike Resseler » Wed May 20, 2015 9:01 am

Hi,

Can you give us more details about this? And if you indeed have an issue with this, we would like you to open a support case so this can be investigated

Thanks

Mike
Mike Resseler
Veeam Software
 
Posts: 2783
Liked: 342 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: VEB and MS SQL backup?

Veeam Logoby Gostev » Wed May 20, 2015 2:19 pm

Mike Resseler wrote:Actually, I did made a mistake on my previous response. SQL truncation does happen, it is Exchange that doesn't happen... Mixed those two up...
Sorry :-(

It's the other way around.
Gostev
Veeam Software
 
Posts: 21146
Liked: 2302 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev

Re: VEB and MS SQL backup?

Veeam Logoby 4c7 » Sun May 24, 2015 10:17 am

Sorry for the late reply.
So if I understand correctly (and I'm not a DBA in any way). We can do SQL backup's with Veeam Endpoint Backup if we use some kind of script or scheduled job that will truncate logs so they don't grow indefinitely, right? Other then that it (Endpoint Backup) does its job (MS SQL Backup) just right?
4c7
Enthusiast
 
Posts: 47
Liked: 3 times
Joined: Mon May 04, 2015 2:45 pm
Full Name: 4c74356b41

Re: VEB and MS SQL backup?

Veeam Logoby Vitaliy S. » Mon May 25, 2015 9:04 am

Ok, I have just re-confirmed it with our QA team - we DO truncate SQL Server database log files, but there are two conditions that have to met in order to make it happen:

1. SQL Server should be installed on the Windows Server box
2. Endpoint service account should have sufficient permissions on the SQL Server

Hope this helps!
Vitaliy S.
Veeam Software
 
Posts: 19231
Liked: 1070 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: VEB and MS SQL backup?

Veeam Logoby mairiesuresnes » Mon Jun 01, 2015 12:59 pm

Mike Resseler wrote:Hi,

Can you give us more details about this? And if you indeed have an issue with this, we would like you to open a support case so this can be investigated

Thanks

Mike

Hello Mike,
Here's the
case ID: 00930833
Thanks
mairiesuresnes
Enthusiast
 
Posts: 26
Liked: 2 times
Joined: Tue Apr 21, 2015 11:50 am
Full Name: Suresnes

Re: VEB and MS SQL backup?

Veeam Logoby Dima P. » Mon Jun 01, 2015 4:57 pm

Hello,

Thanks for the case, I‘ve forwarded it to the QA team for investigation.
Dima P.
Veeam Software
 
Posts: 5843
Liked: 418 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB and MS SQL backup?

Veeam Logoby frankive » Thu Jul 23, 2015 3:12 pm

soo.. it will truncate both sql AND exchange logs?
frankive
Service Provider
 
Posts: 672
Liked: 85 times
Joined: Tue May 14, 2013 8:35 pm
Location: Norway
Full Name: Frank Iversen

Re: VEB and MS SQL backup?

Veeam Logoby EzE » Thu Jul 23, 2015 3:31 pm

Is there a way to DISABLE the log truncation? We are backing up our DB's using SQL server and managing log truncation already. I want to VSS the entire server periodically with Endpoint Backup, but if it truncates the logs it will mess up the normal backups and log files!
EzE
Novice
 
Posts: 9
Liked: never
Joined: Fri Feb 06, 2015 3:48 pm
Full Name: Eric H

Next

Return to Veeam Agent for Windows



Who is online

Users browsing this forum: mingji and 8 guests