VEB and MS SQL backup?

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

Re: VEB and MS SQL backup?

Veeam Logoby Vitaliy S. » Thu Jul 23, 2015 3:42 pm

frankive wrote:it will truncate both sql AND exchange logs?

Yes, that's correct.
EzE wrote: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!

Yes, please contact our support team for further instructions.
Vitaliy S.
Veeam Software
 
Posts: 19698
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: VEB and MS SQL backup?

Veeam Logoby frankive » Thu Jul 23, 2015 4:23 pm

Possible to have the instructions posted here just for a quick reference if we should need the same behaviour?
frankive
Service Provider
 
Posts: 726
Liked: 86 times
Joined: Tue May 14, 2013 8:35 pm
Location: Norway
Full Name: Frank Iversen

Re: VEB and MS SQL backup?

Veeam Logoby Vitaliy S. » Thu Jul 23, 2015 5:21 pm

We do not normally post manual solutions that are not included as one of available options in the UI. Our support team should be able to guide you through this process pretty quickly, after verifying that you are indeed facing the corresponding problem. Thank you for understanding.
Vitaliy S.
Veeam Software
 
Posts: 19698
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: VEB and MS SQL backup?

Veeam Logoby EzE » Thu Jul 23, 2015 7:24 pm

I just tried to remove the veeambackup service account from SQL to see if that works, but I'll open a ticket for a more official fix.

I know that the documentation for Endpoint Backup mentioned earlier covers the SQL truncating, but it would be a good idea to add the verbiage to the GUI itself so that users see it. I was surprised to find out that it attempted to truncate the logs.
EzE
Novice
 
Posts: 9
Liked: never
Joined: Fri Feb 06, 2015 3:48 pm
Full Name: Eric H

Re: VEB and MS SQL backup?

Veeam Logoby ninjaburn81 » Thu Jul 23, 2015 7:33 pm

I think I got a headache from this thread, lol!

So, can we get a final, agreed upon answer here? :) I have a few baremetal boxes running SQL Server Express and would love to know the answer...
ninjaburn81
Enthusiast
 
Posts: 96
Liked: 19 times
Joined: Mon Feb 25, 2013 7:56 pm
Location: Pittsburgh, PA
Full Name: Adam Vogini

Re: VEB and MS SQL backup?

Veeam Logoby frankive » Thu Jul 23, 2015 7:43 pm 1 person likes this post

Vitally confirmed that it will truncate both sql and exchange logs as default.
If you dont want this to happen, contact the support team for a private workaround/fix.
frankive
Service Provider
 
Posts: 726
Liked: 86 times
Joined: Tue May 14, 2013 8:35 pm
Location: Norway
Full Name: Frank Iversen

Re: VEB and MS SQL backup?

Veeam Logoby nick.tan » Thu Aug 27, 2015 2:54 am

Can I check if VEB is application aware so they will leverage on the VSS SQL writers to properly quicesent the SQL database before doing the backup? I will assume this should be the case, since according to vitaliy, VEB can properly do log truncations?

If VEB is not application aware, how can VEB inject the scripting to properly quiescent the Application? (Let's say it is not SQL application, but oracle DB on windows)
nick.tan
Influencer
 
Posts: 15
Liked: never
Joined: Mon Apr 22, 2013 9:17 am
Full Name: Nick Tan

Re: VEB and MS SQL backup?

Veeam Logoby edv@rubner.com » Thu Oct 15, 2015 6:48 am 4 people like this post

Hello,

I have opened a support request and this is the solution:
Veeam EndPoint Backup truncates SQL logs by default. If you want to turn it off please follow instruction below:

1. run regedit
2. go to HKEY_LOCAL_MACHINESOFTWAREVeeamVeeam Endpoint Backup
3. create DWORD value VSSForceCopyOnly = 1
4. re-start Veeam EndPoint Backup service

I've tested it and it works very well on a physical MS SQL Cluster.

Best regards
Michael
edv@rubner.com
Influencer
 
Posts: 16
Liked: 5 times
Joined: Fri Jun 26, 2015 1:35 pm
Full Name: Rubner EDV

Re: VEB and MS SQL backup?

Veeam Logoby Dima P. » Fri Oct 16, 2015 12:48 pm

Hello Michael,

Thanks for sharing. Indeed this is a supported approach of disabling the logs truncation if you need.
Dima P.
Veeam Software
 
Posts: 6385
Liked: 449 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

[MERGED] Multiple Job & dealing with SQL

Veeam Logoby matt_778 » Tue Nov 17, 2015 4:13 am

I have a scenario where I want to perform a volume base backup of a physical SQL server, however this broke the existing SQL log shipping that was setup.
The engineer that was troubleshooting this said:

"It seems that VEEAM may be snapshotting the databases to back them up. In the process it is writing the transaction logs to a NUL file"

So my first question is:
1. Can we exclude Veeam Endpoint from affecting SQL somehow?
2. Can I setup multiple job, so that I capture C: with a volume based job, but the setup a file backup job to just backup SQL .bak files (thus not touching the database/logs which are on D: & E:

Cheers
matt_778
Influencer
 
Posts: 21
Liked: 1 time
Joined: Mon Feb 08, 2010 9:25 am
Full Name: Matt

[MERGED] Re: Multiple Job & dealing with SQL

Veeam Logoby Mike Resseler » Tue Nov 17, 2015 7:36 am

Hi Matt,

1. Yes you can, it requires a registry key (please ask support through the support tab) so it won't truncate the logs. No it will do that by default.
2. You can't select multiple jobs, but you can create one "hybrid" job by selecting file-based backup method, entire volume C: and the specific files on the other volumes. That would give you the volume backup and separate the files on the other volumes.

Mike
Mike Resseler
Veeam Software
 
Posts: 3282
Liked: 365 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

[MERGED] Turn off Application awareness

Veeam Logoby Beheer » Wed Nov 18, 2015 11:12 am

Hi,

We recently started to switch to Veeam as backup solution.
We also use Endpoint Backup for a few servers that are still physical.
A great tool by the way and a very usefull addition to Backup & Replication!

Now I configured a physical SQL server with Endpoint Backup and ran a full backup last week.
The next day a colleague reported that he was missing SQL log files.
It pointed out that they had a construction where SQL logfiles were used to update a read-only database for some purpose.
So only internally scheduled backups at a specific time are allowed, Endpoint backup schould not truncate logs.

Is it possible to create a full backup of this server without application awareness, like in Backup & Replication?
Because I can't find any options in Endpoint Backup. It's a nice product, but not very configurable.

Regards,
Han
Beheer
Novice
 
Posts: 9
Liked: 1 time
Joined: Wed Nov 18, 2015 10:49 am
Full Name: Beheer at Albron

[MERGED] Re: Multiple Job & dealing with SQL

Veeam Logoby matt_778 » Thu Nov 19, 2015 3:38 am 1 person likes this post

Mike,

Veeam support came back with this which worked:

Please run regedit and go to HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Endpoint Backup

Create DWORD value VSSForceCopyOnly = 1, re-start Veeam Backup service and try to backup now
matt_778
Influencer
 
Posts: 21
Liked: 1 time
Joined: Mon Feb 08, 2010 9:25 am
Full Name: Matt

Re: VEB and MS SQL backup?

Veeam Logoby Vitaliy S. » Thu Nov 19, 2015 10:34 am

Try to apply the solution mentioned above.
Vitaliy S.
Veeam Software
 
Posts: 19698
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

[MERGED] Backup MS SQL database

Veeam Logoby iversa » Wed May 11, 2016 8:58 pm

I have a 1 user Maximizer CRM running on my computer which is using MS SQL Express database. If I backup my computer with Veeam Endpoint Backup would I be able to restore the database for MS SQL should disaster ever strike? Or do I need to have some kind of separate backup procedures for the MS SQL database?
iversa
Novice
 
Posts: 5
Liked: never
Joined: Wed May 04, 2016 3:42 pm
Full Name: Gerhard

PreviousNext

Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 10 guests