4 Replies Latest reply: May 2, 2014 1:40 PM by twenden RSS

    SQL Express Maintenance and purging database under ePO 5.1

    twenden

      We are going to migrating the ePO 4.6.7 server to ePO 5.1 in the next few weeks. On the ePO 4.6.7 server, I reindex and remove unused space in the SQL Express 2005 database once a week using the command line script below that uses sqlmaint.

       

      sqlmaint -S VBRHM1A\SQLEXPRESS -D ePO4_VBRHM1A -RebldIdx 15 -UpdOptiStats 15 -RmUnusedSpace 50 10

       

      I noticed that when we upgrade from SQL Express 2005 to SQL Express 2008 R2 that this script no longer runs. It will display the error listed below;

       

      The SQLDMO 'Application' object failed to initialize (specific error: One of the

      library files needed to run this application cannot be found.

       

      Has anyone every come across this error and what it the best way to resolve it. Can't find any info on the McAfee KB regarding purging database with ePO 5.x.