SQL Server Database maintenance for VBR steps

VMware specific discussions

SQL Server Database maintenance for VBR steps

Veeam Logoby albertwt » Mon Nov 16, 2015 11:58 am

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.
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: SQL Server Database maintenance for VBR steps

Veeam Logoby PTide » Mon Nov 16, 2015 12:12 pm

Hi,

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

Thank you.
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm

Re: SQL Server Database maintenance for VBR steps

Veeam Logoby albertwt » Mon Nov 16, 2015 9:41 pm

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.
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: SQL Server Database maintenance for VBR steps

Veeam Logoby PTide » Tue Nov 17, 2015 1:59 pm

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.
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm


Return to VMware vSphere



Who is online

Users browsing this forum: max.che and 22 guests