Comprehensive data protection for all workloads
Post Reply
Troy
Novice
Posts: 4
Liked: never
Joined: Oct 07, 2010 6:43 pm
Full Name: Troy Peters
Contact:

Veeam Database Maintenance Best Practices

Post by Troy »

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.
Vitaliy S.
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

Post by Vitaliy S. »

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!
Troy
Novice
Posts: 4
Liked: never
Joined: Oct 07, 2010 6:43 pm
Full Name: Troy Peters
Contact:

Re: Veeam Database Maintenance Best Practices

Post by Troy »

Yea it does i just wanted to make sure that Veeam did not have any recommendations.

Thanks
Gostev
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

Post by Gostev »

Our configuration database is very small and does not require any special maintenance.
albertwt
Veteran
Posts: 939
Liked: 53 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Re: Veeam Database Maintenance Best Practices

Post by albertwt »

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 ! */
Vitaliy S.
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

Post by Vitaliy S. »

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.
albertwt
Veteran
Posts: 939
Liked: 53 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

[MERGED]: Veeam Backup SQL Server DB maintenance

Post by albertwt »

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:
Configuration database maintenance job. A system job has been added that will
periodically optimize configuration databases, including updating its statistics and
defragmenting indices
So I wonder how to set the frequency and check it if it is already applied or not ?

The SQL Server is located on the separate physical box than the Veeam Backup server.
--
/* Veeam software enthusiast user & supporter ! */
PTide
Product Manager
Posts: 6550
Liked: 765 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Veeam Backup SQL Server DB maintenance

Post by PTide » 1 person likes this post

Hi,
So I wonder how to set the frequency and check it if it is already applied or not ?
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?

Thank you.
albertwt
Veteran
Posts: 939
Liked: 53 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Re: Veeam Backup SQL Server DB maintenance

Post by albertwt »

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.
--
/* Veeam software enthusiast user & supporter ! */
yunales
Influencer
Posts: 17
Liked: 6 times
Joined: Aug 20, 2014 7:34 pm
Full Name: P K
Contact:

Re: Veeam Database Maintenance Best Practices

Post by yunales » 1 person likes this post

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/
GianlucaCroci
Expert
Posts: 231
Liked: 22 times
Joined: Feb 26, 2019 12:08 pm
Full Name: Gianluca Croci
Contact:

Re: Veeam Database Maintenance Best Practices

Post by GianlucaCroci »

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 :D ).
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
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 43 guests