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.
Product Manager
Posts: 24099
Liked: 1815 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
SVP, Product Management
Posts: 26525
Liked: 4155 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
Expert
Posts: 669
Liked: 22 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.
Product Manager
Posts: 24099
Liked: 1815 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
Expert
Posts: 669
Liked: 22 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: 5594
Liked: 536 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
Expert
Posts: 669
Liked: 22 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: 15
Liked: 4 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/

Post Reply

Who is online

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