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.
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.
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.