06-15-2011 09:38 AM
Hello All,
I had a discussion with a SQL admin today, and he asked me some questions I would like to share with you:
Thanks.
Solved! Go to Solution.
06-15-2011 09:59 AM
Yes, you can remove those permissions after the configuration is done. Just be sure to leave the VSA (vault service account) the DBO for the databases. Be sure to remember you have done so if you need to change the configuration in the future. :)
This technote even says it: Article URL http://www.symantec.com/docs/HOWTO28087
If the Enterprise Vault databases are on Microsoft SQL Server 2008, you must grant ALTER ANY LOGIN permission to the Vault Service account before you run the Reporting Configuration utility. You may remove this permission from the Vault Service account when you have quit the Reporting Configuration utility."
EV doesn't use sql jobs for archiving or restoring or anything like that. It will be sql intensive during archiving as it will be adding rows to sql tables. Personally, I always like to SQL dedicated to EV, it makes it easier to manage.
Discovery Accelerator will create SQL jobs, but if you aren't using DA then you don't need to worry about it.
06-15-2011 09:59 AM
Yes, you can remove those permissions after the configuration is done. Just be sure to leave the VSA (vault service account) the DBO for the databases. Be sure to remember you have done so if you need to change the configuration in the future. :)
This technote even says it: Article URL http://www.symantec.com/docs/HOWTO28087
If the Enterprise Vault databases are on Microsoft SQL Server 2008, you must grant ALTER ANY LOGIN permission to the Vault Service account before you run the Reporting Configuration utility. You may remove this permission from the Vault Service account when you have quit the Reporting Configuration utility."
EV doesn't use sql jobs for archiving or restoring or anything like that. It will be sql intensive during archiving as it will be adding rows to sql tables. Personally, I always like to SQL dedicated to EV, it makes it easier to manage.
Discovery Accelerator will create SQL jobs, but if you aren't using DA then you don't need to worry about it.
06-16-2011 02:27 AM
Thanks Tony.
The technote applies to EV 8, do you think it's still relevant for EV 9 ?
Concerning SQL job, I understand your point. I have checked on a platform ( without Discovery, just exchange mailbox archiving,PST migration) and only two jobs are created on SQL:
06-16-2011 05:31 AM
Yes, would still be the same for EV 9.
Oh yeah, good catch on the Monitoring History Purge Job. Those would both be low overhead jobs, I can't see either of them being very intensive. You could always run a SQL Profiler on the two jobs and see what kind of impact they are having.
Honestly, though, I have not ever had anyone ask about them so I have never looked into them too much.
06-17-2011 02:33 AM
Ok I also get the confirmation from the support for the technote.
In fact, it's also the first time i've been asked about and it's an opportunity to learn more about Enterprise Vault ;)