VEB and MS SQL backup?

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

[MERGED] Backup MS SQL database

Veeam Logoby EugeneK » Wed May 11, 2016 10:04 pm

You may want to check this thread.

Thanks!
Eugene K
Product Architect @ SingleHop - Veeam Platinum Service Provider
http://www.singlehop.com
VCAP-DCD, VCAP-DCA, VCP-NV
Veeam Certified Architect
EugeneK
Veeam Vanguard
 
Posts: 102
Liked: 23 times
Joined: Sat Mar 19, 2016 10:57 pm
Location: Chicago, IL
Full Name: Eugene Kashperovetskyi

[MERGED] Backup MS SQL database

Veeam Logoby iversa » Thu May 12, 2016 1:10 am

Thanks for the link! That helps
iversa
Novice
 
Posts: 5
Liked: never
Joined: Wed May 04, 2016 3:42 pm
Full Name: Gerhard

Re: VEB and MS SQL backup?

Veeam Logoby rreed » Tue Oct 11, 2016 2:34 pm

Morning, all. Similar story for us, VEB is breaking our SQL Log Shipping. We have the VSSForceCopyOnly key in place but it's still reaching in and backing up SQL logs (to disk 'NUL' but still backing up logs). Process is VeeamVssSupport\VeeamGuestHelper.exe.

How do we get VEB to leave SQL alone completely and entirely please?
VMware 6
Veeam B&R v9
Dell DR4100's
EMC DD2200's
EMC DD620's
Dell TL2000 via PE430 (SAS)
rreed
Expert
 
Posts: 354
Liked: 72 times
Joined: Tue Jun 30, 2015 6:06 pm

Re: VEB and MS SQL backup?

Veeam Logoby rreed » Tue Oct 11, 2016 3:02 pm

Ah, may have found it. We've done a test restore of our SQL server into a sandbox, and setup a typical VBR job for the test restore. Veeam or VMware seems to be confusing the test server and live one and is backing up the live one via the test job (possibly via same UUID or IP address). Looking into this further...
VMware 6
Veeam B&R v9
Dell DR4100's
EMC DD2200's
EMC DD620's
Dell TL2000 via PE430 (SAS)
rreed
Expert
 
Posts: 354
Liked: 72 times
Joined: Tue Jun 30, 2015 6:06 pm

Re: VEB and MS SQL backup?

Veeam Logoby Dima P. » Tue Oct 11, 2016 4:13 pm

Hi rreed,

When VSSForceCopyOnly is set VEB should not touch the transaction logs, so maybe your guess it right and you observing the behavior of VBR. You are using VEB and VBR on the same test machine with SQL, right?
Dima P.
Veeam Software
 
Posts: 6074
Liked: 433 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB and MS SQL backup?

Veeam Logoby rreed » Tue Oct 11, 2016 9:56 pm

We use VEB on our live SQL servers, VBR on our test SQL servers - that are restores of our VEB covered servers. Apparently since the restore of course has the original's IP address, regardless of being on an isolated, disconnected network, VBR gets confused and backs up the logs on our live servers. I would call that a bug but not sure if that's by design. :wink:

Changed the IP of the test server and the problem went away. Odd, since it's on an isolated/disconnected vSwitch.
VMware 6
Veeam B&R v9
Dell DR4100's
EMC DD2200's
EMC DD620's
Dell TL2000 via PE430 (SAS)
rreed
Expert
 
Posts: 354
Liked: 72 times
Joined: Tue Jun 30, 2015 6:06 pm

Re: VEB and MS SQL backup?

Veeam Logoby Dima P. » Thu Oct 13, 2016 12:26 pm

Thanks for the heads up! It looks like VBR injected the component for SQL transaction log backup to the wrong machine since IP address were identical. Can you clarify how the test SQL was restored (was that an export to virtual disk or BMR to VM)?
Dima P.
Veeam Software
 
Posts: 6074
Liked: 433 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB and MS SQL backup?

Veeam Logoby rreed » Thu Oct 13, 2016 1:29 pm

BMR to VM.
VMware 6
Veeam B&R v9
Dell DR4100's
EMC DD2200's
EMC DD620's
Dell TL2000 via PE430 (SAS)
rreed
Expert
 
Posts: 354
Liked: 72 times
Joined: Tue Jun 30, 2015 6:06 pm

Re: VEB and MS SQL backup?

Veeam Logoby Dima P. » Thu Oct 13, 2016 2:17 pm

Got it, thanks. BMR restores the network adapter in original state, so that’s why you got the IP address duplicated and that confused the VBR’s transaction log backup utility.
Dima P.
Veeam Software
 
Posts: 6074
Liked: 433 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB and MS SQL backup?

Veeam Logoby rreed » Thu Oct 13, 2016 2:25 pm

Very good. Would this be something to fix? Perhaps go by VM name, or UUID if the restored VM gets a different one since for VEB into VMware, we create a new VM from scratch and do a BMR?
VMware 6
Veeam B&R v9
Dell DR4100's
EMC DD2200's
EMC DD620's
Dell TL2000 via PE430 (SAS)
rreed
Expert
 
Posts: 354
Liked: 72 times
Joined: Tue Jun 30, 2015 6:06 pm

Re: VEB and MS SQL backup?

Veeam Logoby Mike Resseler » Thu Oct 13, 2016 2:33 pm

The problem with BMR to VM means we don't know that it is a VM, we are performing a Bare Metal Restore and that could be physical and virtual... So we literally restore every setting. I would suggest that if you do a test BMR (and sandbox it) that you still change the IP address if you are going to do specific tests like that. (I personally would also even change the name of the server to something like <originalname>-test)
Mike Resseler
Veeam Software
 
Posts: 3088
Liked: 359 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 rreed » Thu Oct 13, 2016 2:41 pm

Very good. If it helps, I was thinking of this as more of a Veeam issue than VBR, since it's a typical Veeam backup job that gets confused. VEB is doing its job perfectly. :D We'll make it a note to change IP's when we do test restores and go from there.
VMware 6
Veeam B&R v9
Dell DR4100's
EMC DD2200's
EMC DD620's
Dell TL2000 via PE430 (SAS)
rreed
Expert
 
Posts: 354
Liked: 72 times
Joined: Tue Jun 30, 2015 6:06 pm

Previous

Return to Veeam Agent for Windows



Who is online

Users browsing this forum: Bing [Bot] and 4 guests