Hi team,
I have migrated my VeeamONE database (v12) to another SQL Server (standard edition). I'm following the kb: https://www.veeam.com/kb1599
On my other SQL Server didn't have this job, so I created it:
[Recommended, but SQL License Dependant]
If the destination SQL Instance where the Veeam ONE database was migrated to runs a licensed version (non-express) of SQL, create the index defragmentation maintenance job using this script. After creating the VeeamONE Maintenance Job_VeeamONE job, find it under SQL Server Agent > Jobs and enable it.
Just two questions...
The job has to be for the VeeamONE DB, correct?
And when is it executed? I have enabled it but it appears unplanned, does VeeamONE run it on demand?
As far as I remember, this task was included in the monitor service, so there is no need to do that step anymore. However, I don't remember the exact version. Will check with our QA and we'll improve the KB text.
Did we find out if this was true? Does 12.3 need the index defrag maint job, or is that included in another process in 12.3? I don't spy any updated info in the docs.
I upgraded to 12.3 last week. Many of my index appear to be pretty badly fragmented, so I'm not confident it's being taken care of automatically.
Indeed, the KB is not changed. I'll find out why.
I can confirm that we have moved the defragmentation into the Monitor service. Therefore, the task is no longer needed, it should be removed during the upgrade to version 12.1 and above.
Also, please if there are concerns about indexes, open a support case so we could collect all the additional details and investigate it accordingly.