cancel
Showing results for 
Search instead for 
Did you mean: 

ePO 4.6 SQL Database maintenance plan

Hi All,

McAfee KB67184 details maintenance plan settings beyond backup for the ePO 4.0\4.5 SQL databases - does anyone know if these maintenance steps specifically; Check Database Integrity and Rebuild Index for the DB are recommended for v4.6?

I do this with 4.5 so I assume the same is true for 4.6 does anyone have any information regarding this? I may open up a call with McAfee but I thought I'd check here first.

Thanks

Mark

4 Replies
Highlighted
McAfee Employee spamidi
McAfee Employee
Report Inappropriate Content
Message 2 of 5

Re: ePO 4.6 SQL Database maintenance plan

Yes - they are recommeded - irrespective of the ePO version. Database Maintenance is not specific to ePO - this is needed to maintain the overall health of the user databases - which includes the ePO database. Hope that answers your query.

Re: ePO 4.6 SQL Database maintenance plan

thanks for the info - i will go ahead and apply it to backend DB

McAfee Employee JoeBidgood
McAfee Employee
Report Inappropriate Content
Message 4 of 5

Re: ePO 4.6 SQL Database maintenance plan

Actually, you might run into a small problem with this, as in you may see some errors during the index reorganisation step (assuming you have one.)  This is nothing to worry about   Some changes have eben made to the database from epo 4.5.4 onwards - please see KB73170 for details. I'm hoping to update this (and other related) articles with a script that should handle this without errors.

HTH -

Joe

Re: ePO 4.6 SQL Database maintenance plan

thanks thats great!

Mark

More McAfee Tools to Help You
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • Visit: Business Service Portal
  • More: Search Knowledge Articles
  • ePolicy Orchestrator Support
  • The McAfee ePO Support Center Plug-in is now available in the Software Manager. Follow the instructions in the Product Guide for more.