For what is SQL Installation needed? Endpoint Protection

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

For what is SQL Installation needed? Endpoint Protection

Veeam Logoby stvajnkf » Tue Apr 25, 2017 4:58 pm

Hi,

iam currently testing Endpoint Protection and i was wondering, for what exactly is the installation of SQL needed? I deactivated the SQL service and a Backup was still possible.
Does it have any side effects if I leave the SQL service disabled?
stvajnkf
Novice
 
Posts: 8
Liked: 1 time
Joined: Tue Jan 03, 2017 5:25 pm
Full Name: nothanks@no.com

Re: For what is SQL Installation needed? Endpoint Protection

Veeam Logoby Dima P. » Tue Apr 25, 2017 8:50 pm

Hello stvajnkf,

SQL DB keeps you job settings and if you disable it VEB/VAW wont work.
Dima P.
Veeam Software
 
Posts: 6388
Liked: 449 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: For what is SQL Installation needed? Endpoint Protection

Veeam Logoby stvajnkf » Wed Apr 26, 2017 4:53 am

Thats weird, because i disabled the service "SQL Servcer VSS Writer" and doing a backup is no problem.
stvajnkf
Novice
 
Posts: 8
Liked: 1 time
Joined: Tue Jan 03, 2017 5:25 pm
Full Name: nothanks@no.com

Re: For what is SQL Installation needed? Endpoint Protection

Veeam Logoby Mike Resseler » Wed Apr 26, 2017 6:01 am

Hi Stvajnkf,

When you disable the SQL Service VSS writer you don't disable the database. It is still running under another service. This specific service is part of the VSS framework.

The Database Engine locks and has exclusive access to the data files. When the SQL Writer Service is not running, backup programs running in Windows do not have access to the data files, and backups must be performed using SQL Server backup. (but specifically for the SQL data, the rest of the backup on your machine will work through other writers)

Hope it makes sense
Mike
Mike Resseler
Veeam Software
 
Posts: 3287
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

Re: For what is SQL Installation needed? Endpoint Protection

Veeam Logoby stvajnkf » Wed Apr 26, 2017 6:32 am

No, sorry. I dont understand it. :oops: The SQL Service VSS writer came with the Installation of Endpoint Protection. I prefer to not have any unnecessary services running in the backround. Everything seems to work without this service, but I am not sure about it. Thats why I am asking. Sorry if I am dumb :oops:
stvajnkf
Novice
 
Posts: 8
Liked: 1 time
Joined: Tue Jan 03, 2017 5:25 pm
Full Name: nothanks@no.com

Re: For what is SQL Installation needed? Endpoint Protection

Veeam Logoby Mike Resseler » Wed Apr 26, 2017 7:12 am

First, asking questions is not what I consider dumb ;-)

The VSS framework is a solution from Microsoft that allows to take backups from files or applications (for example, Exchange and SharePoint also have a specific VSS writer) even if those applications are running. (Remember the good old days when you had to create scripts to stop a certain application before backup and start it again after backup...). Through this VSS framework this is not necessary anymore. You create a snapshot, you can take the backup, and release the snapshot and all applications were continuously running. PS: That service comes with SQL DB and not with Endpoint :-)

I am not going into much detail about VSS but in essence you have a requestor (in this case, a backup application), a writer (specifically for the app, so SQL, Exchange but also for the file system, WMI and so on and so forth. Run vssadmin list writers in an elevated command prompt to see the ones that are in use) and finally a provider (kind of the service that is the "organizer" of this and arranges everything between the components).

Even if that service is running, it won't take resources. It will stay idle until it is being "called" or "requested" (so only during backup)

If you let it run, basically your databases (although it is probably only the one from Endpoint) will be requested to get into a consistent state and you will not end up with a potential data issue for that database

If additional questions or still not clear, let me know
Mike Resseler
Veeam Software
 
Posts: 3287
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

Re: For what is SQL Installation needed? Endpoint Protection

Veeam Logoby stvajnkf » Wed Apr 26, 2017 10:43 am

Thanks, that makes things clearer. :-)

Funny, that you mention scripts, because thats how my backup look likes. My plan is, to expand my current script with start/stop commands for the VeeamEndpointBackupSvc and the SQL Service VSS writer. So that these services only run, when the backup is supposed to start. Iam not goint to use the buildin scheduler. This also seems to work without problems during my tests. And when both services are disabled until there are need, there should not be any inconsistent data, hopefully...^^
stvajnkf
Novice
 
Posts: 8
Liked: 1 time
Joined: Tue Jan 03, 2017 5:25 pm
Full Name: nothanks@no.com

Re: For what is SQL Installation needed? Endpoint Protection

Veeam Logoby Mike Resseler » Thu Apr 27, 2017 6:05 am

Interesting scenario.

One of the reasons we used this localDB (it is not really SQL but a very light version of it, specifically designed by MSFT for this) and the fact that we limit our resources (background) you should not be able to see any effect (besides a minor 200 MB of ram or so...) during normal operations. In fact, we also did this because we originally designed it for endpoints and you don't want photoshop/ word/ powerpoint to become slower when the backup runs, or is in background mode :-)

Anyway, keep us informed how it works further and if you encounter issues

Cheers
Mike
Mike Resseler
Veeam Software
 
Posts: 3287
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

Re: For what is SQL Installation needed? Endpoint Protection

Veeam Logoby stvajnkf » Thu Apr 27, 2017 7:50 am 1 person likes this post

Thank you for your support and your help. I actually expected that you would say something like "Good luck with that, don't ask us when you run into problems..." (I have seen this before on other topics).
Seeing that you still offer me support shows me, that I have chosen the right Backup Solution. If something does not work as expected I will post an Update :-) Thanks alot.
stvajnkf
Novice
 
Posts: 8
Liked: 1 time
Joined: Tue Jan 03, 2017 5:25 pm
Full Name: nothanks@no.com

Re: For what is SQL Installation needed? Endpoint Protection

Veeam Logoby stvajnkf » Sun Apr 30, 2017 5:33 pm

Hi,

i got another question: When the Backup is running via Command Line, the setting "Backup no more often than x days" seems not to work. I set it on 1 Day but it gets ignored. The Backup also finish with warning everytime. Backup location is getting low on free disk space (396,6 GB free of 5,3 TB). Is there a setting I could make to avoid this warning (except get more free space :P )?
stvajnkf
Novice
 
Posts: 8
Liked: 1 time
Joined: Tue Jan 03, 2017 5:25 pm
Full Name: nothanks@no.com

Re: For what is SQL Installation needed? Endpoint Protection

Veeam Logoby hoFFy » Mon May 01, 2017 4:36 am

Hi,

AFAIK works the "no more than x times settings" only with the integrated scheduler. This is per design. I'm wondering how you schedule the start-stop of the services - when you do this with the Windows task planner you must have an exact plan how often backups run per day. Or did I misunderstand you?
The warning for the backup location comes after less than 10% of free space are available. But a RegKey could help you, try searching the forum or use this link: post229730.html?hilit=Is%20getting%20low#p229730
VMCE 7 / 8 / 9, VCP-DC 5 / 5.5 / 6, MCITP:SA
Blog: machinewithoutbrain.de
hoFFy
Veeam ProPartner
 
Posts: 162
Liked: 25 times
Joined: Fri Apr 27, 2012 1:10 pm
Location: Germany / Lohne
Full Name: Sebastian Hoffmann

Re: For what is SQL Installation needed? Endpoint Protection

Veeam Logoby stvajnkf » Mon May 01, 2017 6:19 am

Thanks alot, I hoped for a RegKey. :-) Too bad, there only one for the warning. I got a script in my autostart. This script checks if its friday and if so, the Veeam services will be started and also the backup. When I restart the PC, the backup executes again. Hoped there would be a solution too. Since my usercase is a little more special I can understand why there is none. :wink:
stvajnkf
Novice
 
Posts: 8
Liked: 1 time
Joined: Tue Jan 03, 2017 5:25 pm
Full Name: nothanks@no.com


Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 17 guests