-
- 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
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
It still needs to be done in the registry.
https://www.veeam.com/kb2104
-
- Product Manager
- Posts: 9787
- Liked: 2585 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
Hi Tom
Are you looking to exclude the database from our <log backup feature> or just from <log truncation>?
Best,
Fabian
Are you looking to exclude the database from our <log backup feature> or just from <log truncation>?
Best,
Fabian
Product Management Analyst @ Veeam Software
-
- 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
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.
-
- Product Manager
- Posts: 9787
- Liked: 2585 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
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
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
-
- 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
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.
-
- Product Manager
- Posts: 9787
- Liked: 2585 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
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
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
-
- 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
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.
But it would really a nice to have add this in the GUI in the current jobs I created for the VM.
-
- 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
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.
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.
-
- 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
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.
-
- Veeam Software
- Posts: 3608
- Liked: 604 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
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!
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!
-
- 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
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.
-
- 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
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.
Who is online
Users browsing this forum: No registered users and 2 guests