[Feature Request] GUI-Exclude MS SQL Databases from SQL Log backup

[tbeekmans]

Exclude MS SQL Databases from SQL Log backup, it would really be great in to have this in GUI.
It still needs to be done in the registry.

https://www.veeam.com/kb2104

[Mildur]

Hi Tom

Are you looking to exclude the database from our <log backup feature> or just from <log truncation>?

Best,
Fabian

[tbeekmans]

I'm looking for the option "log backup feature" I have ERP DB's and I need to backup the changes every hour this avoid loss of data in case of.

[Mildur]

Thank you. We will keep monitoring how many votes we get for this request.

I have some more questions if you would like to answer.
May I ask, why you don't use our <Transaction Log> backup option? Do you prefer to use MSSQL built in log backup mechanisms?
We also have a MSSQL plugin which you can deploy on the MSSQL server to create database and transaction log backups on an hourly interval.

Best,
Fabian

[tbeekmans]

With the MSSQL plugin can you schedule this task (every hour)? Because I installed the SQL Agent on the SQL server and couldn't find it, maybe you can send me a KB.

[Mildur]

There are two ways to backup transaction log with a Veeam product every 1 hour.

Per VM or Agent job:
You have to configure transaction log backup every 1 hour in the guest processing settings. https://helpcenter.veeam.com/docs/backu ... ml?ver=120

Or per MSSQL Plugin:
1. Install the plugin, configure backup settings and save it as a SQL agent job.
2. Schedule can now be configured in the properties of the SQL agent job in MSSQL studio
https://helpcenter.veeam.com/docs/backu ... p-schedule

Best,
Fabian

[tbeekmans]

Thx a lot, you pointed me to the a good solution (SQL Agent) this is more easy then the registry settings and I can work whit this.
But it would really a nice to have add this in the GUI in the current jobs I created for the VM.

[tbeekmans]

The thing is you backup a complete VM (SQL server,) with a lot of DB's and you don't want to backup the transaction log for all DB's.
And even with the Agent(s) it isn't possible to make any exclusions, it will redirect to SQL Management Studio job and not Veeam Repository.

[tbeekmans]

It would be really nice if you could select in the backup job, which DB's of SQL you want to backup and not the entire VM.

[PetrM]

Hi Tom,

Let's imagine that there is a new job in Veeam B&R which allows you to select the specific DBs and trigger a backup by SQL plug-in from Veeam B&R console, would it work for you?

Or the underlying technology is important and you absolutely need this flexible selection in the already existing image-level job with application-aware image processing? For example, you want to process some DBs and make a machine backup within a single job.

Thanks!

[tbeekmans]

Yes, it's now problem if I need to install a SQL Agent on the VM (SQL server) if I can select in the job which DB's I want to backup.

[tbeekmans]

Hopefully soon in new releases, you can select in the backup job itself to select a dedicated DB for backups logs periodically and not for all DB's on the SQL server.