-
- Novice
- Posts: 4
- Liked: never
- Joined: Oct 07, 2010 6:43 pm
- Full Name: Troy Peters
- Contact:
Veeam Database Maintenance Best Practices
Does Veeam have a best practices recommendations for database maintenance on its own SQL databases? I have been unable to find anything that really has this information.
-
- VP, Product Management
- Posts: 27365
- Liked: 2794 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Veeam Database Maintenance Best Practices
Troy, I would suggest following best practices from Microsoft for SQL database maintenance. Regarding Veeam configuration database, you won't see a significant grow for either the database or transaction logs. Hope it helps!
-
- Novice
- Posts: 4
- Liked: never
- Joined: Oct 07, 2010 6:43 pm
- Full Name: Troy Peters
- Contact:
Re: Veeam Database Maintenance Best Practices
Yea it does i just wanted to make sure that Veeam did not have any recommendations.
Thanks
Thanks
-
- Chief Product Officer
- Posts: 31780
- Liked: 7280 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: Veeam Database Maintenance Best Practices
Our configuration database is very small and does not require any special maintenance.
-
- Veteran
- Posts: 939
- Liked: 53 times
- Joined: Nov 05, 2009 12:24 pm
- Location: Sydney, NSW
- Contact:
Re: Veeam Database Maintenance Best Practices
thanks for all of the reply guys, so what happened to the Veeam application when somehow the SQL Server DB got crash and needs to be restored, does VBR can still operate normally ?
--
/* Veeam software enthusiast user & supporter ! */
/* Veeam software enthusiast user & supporter ! */
-
- VP, Product Management
- Posts: 27365
- Liked: 2794 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Veeam Database Maintenance Best Practices
Albert, you need to have Veeam configuration db up and running to operate VBR normally, though if you need to perform an urgent restore, you may use an extract utility or install a new backup server, import the backup files and perform a restore.
-
- Veteran
- Posts: 939
- Liked: 53 times
- Joined: Nov 05, 2009 12:24 pm
- Location: Sydney, NSW
- Contact:
[MERGED]: Veeam Backup SQL Server DB maintenance
Hi All,
After reading http://veeampdf.s3.amazonaws.com/new/ve ... new_en.pdf on page 7, there is new feature for SQl Database maintenance:
The SQL Server is located on the separate physical box than the Veeam Backup server.
After reading http://veeampdf.s3.amazonaws.com/new/ve ... new_en.pdf on page 7, there is new feature for SQl Database maintenance:
So I wonder how to set the frequency and check it if it is already applied or not ?Configuration database maintenance job. A system job has been added that will
periodically optimize configuration databases, including updating its statistics and
defragmenting indices
The SQL Server is located on the separate physical box than the Veeam Backup server.
--
/* Veeam software enthusiast user & supporter ! */
/* Veeam software enthusiast user & supporter ! */
-
- Product Manager
- Posts: 6550
- Liked: 765 times
- Joined: May 19, 2015 1:46 pm
- Contact:
Re: Veeam Backup SQL Server DB maintenance
Hi,
Thank you.
It has a predefined schedule to run once a week. Also it starts every time you restart Veeam service. As it is purely a system tool and is not supposed to be controlled its behaviour can be changed only via registry keys. May I ask you why do you want to change the frequency?So I wonder how to set the frequency and check it if it is already applied or not ?
Thank you.
-
- Veteran
- Posts: 939
- Liked: 53 times
- Joined: Nov 05, 2009 12:24 pm
- Location: Sydney, NSW
- Contact:
Re: Veeam Backup SQL Server DB maintenance
Hi PTide,
I just wanted to know that if the SQL maintenance job has been implemented or not because I already got the existing SQL maintenance job since Veeam V7.0 for all DB in the SQL server 2012 box.
I just wanted to know that if the SQL maintenance job has been implemented or not because I already got the existing SQL maintenance job since Veeam V7.0 for all DB in the SQL server 2012 box.
--
/* Veeam software enthusiast user & supporter ! */
/* Veeam software enthusiast user & supporter ! */
-
- Influencer
- Posts: 17
- Liked: 6 times
- Joined: Aug 20, 2014 7:34 pm
- Full Name: P K
- Contact:
Re: Veeam Database Maintenance Best Practices
I'm using the free DB maintenance solution from Ola Hallengren. Just let it run on a daily basis for best DB performance.
https://ola.hallengren.com/
https://ola.hallengren.com/
-
- Expert
- Posts: 231
- Liked: 22 times
- Joined: Feb 26, 2019 12:08 pm
- Full Name: Gianluca Croci
- Contact:
Re: Veeam Database Maintenance Best Practices
Hello,
8 years have passed since the last modification of this post, and several versions of Veeam B&R have changed, as well as of SQL (but this one has probably not changed as much as Veeam ).
Has anything changed in the meantime regarding the maintenance of Veeam database or is maintenance directly in SQL still the only option?
Thanks a lot
Regards
8 years have passed since the last modification of this post, and several versions of Veeam B&R have changed, as well as of SQL (but this one has probably not changed as much as Veeam ).
Has anything changed in the meantime regarding the maintenance of Veeam database or is maintenance directly in SQL still the only option?
Thanks a lot
Regards
Who is online
Users browsing this forum: Bing [Bot] and 43 guests