SQL Server database maintenance for VeeamONE ?

[albertwt]

Hi All,

Does anyone here know what's the best way to perform SQL Database maintenance for Veeam ONE monitor DB ?

is it really necessary ?

Thanks,

[Vitaliy S.]

All regular maintenance tasks are already scheduled, so you should be good here. Apart from that, depending on the size of the infrastructure, sometimes we require to do indexing/rebuild indexes for particular tables. What size of the infrastructure do you currently have?

[albertwt]

Hi Vitaliy,

Size is not that big:

1x VCenter
16x ESXi on HP Blades
170+ Vms running at the moment.

So by default is there any SQL Agent task to do this maintenance ? Or do I need to create it manually ?

[Vitaliy S.]

Ok, in this case you may want to schedule index rebuild on weekly basis. Here is an existing article for more info on how to do it > https://technet.microsoft.com/en-us/lib ... .120).aspx

P.S. we will be adding this task in our next updates for your convenience.

[albertwt]

Ah I see,

So is it for the next VeeamONE Update 3 ? or the next Veeam 9 ?

[Vitaliy S.]

v9 is in the code lock state and is coming soon. This task is optional and most likely will be in the next updates.