Page 1 of 1

SQL Server Database maintenance for VBR steps

Veeam LogoPosted: Mon Nov 16, 2015 11:58 am
by albertwt
People,

Can anyone here share what's the best way to perform SQL Database maintenance for Veeam Backup & Recovery DB ?

Ever since I migrate the SQL DB from the builtin express edition to the stand alone SQL Server same with VeeamONE, there is no SQL DB maintenance task to optimize it.

Thanks in advance.

Re: SQL Server Database maintenance for VBR steps

Veeam LogoPosted: Mon Nov 16, 2015 12:12 pm
by PTide
Hi,

There will be a maintenance job in VBR v9. Do you experience any particular issues with your database now? Please clarify.

Thank you.

Re: SQL Server Database maintenance for VBR steps

Veeam LogoPosted: Mon Nov 16, 2015 9:41 pm
by albertwt
Hi Pavel,

No I don't feel anything :-)
but in my other SQL Server DB for let say Symantec Enterprise Vault, there is a custom job created by my DBA according to Symantec Technote article to do the suggested maintenance.

So in this case I wonder if Veeam have some tips in how to mainteain the SQL DB in shape.
Note: I'm about to migrate this SQL DB to another SQL Server box so might as well put some maintenance task after it is deployed.

Re: SQL Server Database maintenance for VBR steps

Veeam LogoPosted: Tue Nov 17, 2015 1:59 pm
by PTide
We do not have such guidelines. Veeam database contains only configuration tables for your backup jobs and not the actual backup files, so almost nothing to optimize.

I think that I've seen some tech notes from Veritas on that topic too. Currently the only form of maintenance that is available is configuration backup. In v9 there will be a maintenance job to cover the reorganization/rebuild of the indexes on tables, database statistics updates, and a few more things.

Thank you.