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 » Oct 12, 2010 4:38 pm

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: 23201
Liked: 1605 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam Database Maintenance Best Practices

Post by Vitaliy S. » Oct 12, 2010 6:06 pm

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 » Oct 12, 2010 7:38 pm

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

Thanks

Gostev
SVP, Product Management
Posts: 25094
Liked: 3673 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Veeam Database Maintenance Best Practices

Post by Gostev » Oct 13, 2010 1:47 pm

Our configuration database is very small and does not require any special maintenance.

albertwt
Expert
Posts: 643
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Re: Veeam Database Maintenance Best Practices

Post by albertwt » Oct 14, 2010 1:10 pm

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: 23201
Liked: 1605 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam Database Maintenance Best Practices

Post by Vitaliy S. » Oct 14, 2010 1:35 pm

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: 643
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

[MERGED]: Veeam Backup SQL Server DB maintenance

Post by albertwt » Apr 19, 2016 3:15 am

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: 5343
Liked: 468 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Veeam Backup SQL Server DB maintenance

Post by PTide » Apr 19, 2016 9:13 am 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: 643
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Re: Veeam Backup SQL Server DB maintenance

Post by albertwt » Apr 19, 2016 12:28 pm

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 » Apr 19, 2016 6:23 pm 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], Google [Bot], Hiroyuki Uemura, ta_yoshizumi and 31 guests