veeam agent on microsoft sql server

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

veeam agent on microsoft sql server

Veeam Logoby neilmacneil » Wed Jul 26, 2017 7:03 pm

Hello,

I've attempted to install Veeam Agent for Windows on our primary Microsoft Database server. This did not cause issues with database connections itself but it did break the schedule SQL backups. Is there a way I can install veeam agent and have it use the existing sql db that the server is running? Or another work around?

Thanks,

-Neil
neilmacneil
Service Provider
 
Posts: 51
Liked: 2 times
Joined: Thu Mar 05, 2015 2:17 pm
Full Name: Neil MacNeil

Re: veeam agent on microsoft sql server

Veeam Logoby neilmacneil » Wed Jul 26, 2017 7:23 pm

support case 02260092
neilmacneil
Service Provider
 
Posts: 51
Liked: 2 times
Joined: Thu Mar 05, 2015 2:17 pm
Full Name: Neil MacNeil

Re: veeam agent on microsoft sql server

Veeam Logoby Dima P. » Wed Jul 26, 2017 10:52 pm

Hello Neil,

Is there a way I can install veeam agent and have it use the existing sql db that the server is running?

To tell the truth I never tried to use non bundled sql. Need some time to check.
it did break the schedule SQL backups

So VAW is interfering with native sql backup is that correct? Are you running agent in server edition with application aware processing and transaction log backup being enabled? Thanks.
Dima P.
Veeam Software
 
Posts: 6739
Liked: 482 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: veeam agent on microsoft sql server

Veeam Logoby neilmacneil » Thu Jul 27, 2017 4:32 pm

Hey,

I installed the latest and greatest agent (unlicensed/free edition). I didn't reboot the server after I had installed Veeam and for some odd reason our SQL backup jobs started to fail later that night. I was able to reboot the box yesterday and veeam agent took a backup without issue. Also the SQL differentials ran as normal after the reboot.

Thanks,
02260092
-Neil
neilmacneil
Service Provider
 
Posts: 51
Liked: 2 times
Joined: Thu Mar 05, 2015 2:17 pm
Full Name: Neil MacNeil

Re: veeam agent on microsoft sql server

Veeam Logoby Dima P. » Thu Jul 27, 2017 4:51 pm

Good, thanks for the update. Free mode means copy only snapshot should be created for your SQL DB and it should not interfere with native utilities (from top of my head there might be issues only when schedule of full backup is overlapping with sql backup). Please keep investigating this issue with our support team and let us know how it goes.
Dima P.
Veeam Software
 
Posts: 6739
Liked: 482 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: veeam agent on microsoft sql server

Veeam Logoby neilmacneil » Tue Aug 01, 2017 5:41 pm 1 person likes this post

Yeh it was odd for sure. I'm not 100% what the issue was but it was related to having veeam installed, not doing a reboot after the installation and then doing a veeam backup while sql log backups were running unknowingly. So, reboot your servers after install Veeam agent!
neilmacneil
Service Provider
 
Posts: 51
Liked: 2 times
Joined: Thu Mar 05, 2015 2:17 pm
Full Name: Neil MacNeil


Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 1 guest