Backup of enterprise applications (Microsoft stack, IBM Db2, MongoDB, Oracle, PostgreSQL, SAP)
Post Reply
tbeekmans
Influencer
Posts: 23
Liked: 8 times
Joined: Sep 07, 2018 12:13 pm
Full Name: Tom Beekmans
Contact:

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

Post by 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
Product Manager
Posts: 9848
Liked: 2610 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

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

Post by Mildur »

Hi Tom

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

Best,
Fabian
Product Management Analyst @ Veeam Software
tbeekmans
Influencer
Posts: 23
Liked: 8 times
Joined: Sep 07, 2018 12:13 pm
Full Name: Tom Beekmans
Contact:

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

Post by 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
Product Manager
Posts: 9848
Liked: 2610 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

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

Post by 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
Product Management Analyst @ Veeam Software
tbeekmans
Influencer
Posts: 23
Liked: 8 times
Joined: Sep 07, 2018 12:13 pm
Full Name: Tom Beekmans
Contact:

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

Post by 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
Product Manager
Posts: 9848
Liked: 2610 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

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

Post by 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
Product Management Analyst @ Veeam Software
tbeekmans
Influencer
Posts: 23
Liked: 8 times
Joined: Sep 07, 2018 12:13 pm
Full Name: Tom Beekmans
Contact:

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

Post by 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
Influencer
Posts: 23
Liked: 8 times
Joined: Sep 07, 2018 12:13 pm
Full Name: Tom Beekmans
Contact:

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

Post by 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
Influencer
Posts: 23
Liked: 8 times
Joined: Sep 07, 2018 12:13 pm
Full Name: Tom Beekmans
Contact:

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

Post by 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
Veeam Software
Posts: 3626
Liked: 608 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

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

Post by 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
Influencer
Posts: 23
Liked: 8 times
Joined: Sep 07, 2018 12:13 pm
Full Name: Tom Beekmans
Contact:

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

Post by tbeekmans » 1 person likes this post

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
Influencer
Posts: 23
Liked: 8 times
Joined: Sep 07, 2018 12:13 pm
Full Name: Tom Beekmans
Contact:

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

Post by tbeekmans » 1 person likes this post

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.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest