Prevent Endpoint from backing up SQL on a SQL server

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

Prevent Endpoint from backing up SQL on a SQL server

Veeam Logoby netmonkey » Wed May 18, 2016 11:12 am

Hi -

I have a physical windows 2008R2 server running SQL 2008R2
the same server also has a large file share (1TB) on a dedicated volume (drive F:\)

I want to use Endpoint to backup that file share on the F:\ drive, but not touch anything else
We have a third party SQL backup tool that takes care of SQL backups on that server and I want to carry on using that for the SQL stuff

Couple of questions -

1. Will Endpoints SQL2012 express install interfere with our SQL2008R2 install on that server
2. If I configure Endpoint to use "Volume level backup" or "File level backup" on the file share F:\ drive, will Endpoints "application aware" feature definitely ignore our SQL2008R2 databases

I just want Endpoint to backup the file share folder - nothing else.

regards!
netmonkey
Novice
 
Posts: 8
Liked: 1 time
Joined: Wed Dec 29, 2010 9:26 am

Re: Prevent Endpoint from backing up SQL on a SQL server

Veeam Logoby JaxIsland7575 » Wed May 18, 2016 1:32 pm

If you configure File Level Backup and choose that single folder than nothing with SQL should be backed up.

Cheers!
VMCE v9
JaxIsland7575
Veeam Vanguard
 
Posts: 364
Liked: 98 times
Joined: Mon Apr 27, 2015 1:59 pm
Location: NY, USA
Full Name: Ryan Jacksland

Re: Prevent Endpoint from backing up SQL on a SQL server

Veeam Logoby netmonkey » Wed May 18, 2016 5:03 pm

No luck with this...

I tried the "File Level backup (slower)" option, selected a single 30Mb folder for testing and ran the job.
the destination was a B&R repository elsewhere on our network.

20 mins later the job was sat at 99% complete

I went into 2008R2 Management studio and into the SQL logs and sure enough Endpoint was in the middle of doing Log backups of all our production databases.

Looks like the "application aware" feature in Endpoint can't help itself if it detects SQL installed... even if you're doing just a file level backup.

is there a registry tweak maybe to turn this off?

cheers...
netmonkey
Novice
 
Posts: 8
Liked: 1 time
Joined: Wed Dec 29, 2010 9:26 am

Re: Prevent Endpoint from backing up SQL on a SQL server

Veeam Logoby netmonkey » Thu May 19, 2016 8:28 am 1 person likes this post

May have found something on this - there's a thread from last year discussing the same issue.

veeam-endpoint-backup-f33/endpoint-backup-ms-sql-backup-t27878-15.html

looks like adding a registry key of 'DWORD value VSSForceCopyOnly = 1' disables endpoints 'application awareness' feature and stops it trying to backup any SQL/Exchange/AD etc it finds...

would like confirmation of this from someone at veeam if possible?

cheers.
netmonkey
Novice
 
Posts: 8
Liked: 1 time
Joined: Wed Dec 29, 2010 9:26 am

Re: Prevent Endpoint from backing up SQL on a SQL server

Veeam Logoby Dima P. » Thu May 19, 2016 12:36 pm

Hi folks,

Indeed, VEB performs logs truncation by default when it is installed on a Windows Server. The described key should disable log truncation.
Dima P.
Veeam Software
 
Posts: 6261
Liked: 441 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov


Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 11 guests