Showing results for 
Show  only  | Search instead for 
Did you mean: 
Level 10
Report Inappropriate Content
Message 1 of 5

Upgrade ePO 4.5 DB from SQL 2005 to SQL 2008

My organization's database administrators are considering upgrading my ePO's database server (which is separate from the ePO) from MS SQL 2005 to MS SQL 2008.  Aside from downing the ePO while the upgrade occurs, is anyone aware of any caveats in performing such an upgrade?  Thanks!

4 Replies

Re: Upgrade ePO 4.5 DB from SQL 2005 to SQL 2008

I would also be interested in the best and most painless way to go about this upgrade as well. We are also on 2005 and need to go to 2008 in addition to upgrading the OS that the server is on from windows server 2003 to 2008 to take advantage of all the memory in the server as well. Current setup is DOG slow!!


Re: Upgrade ePO 4.5 DB from SQL 2005 to SQL 2008

Migrating ePO to new OS:

Moving database:

- Stop all epo services

- move database to new server

- restore database on new server and establish the proper security settings (e.g. user access)

- detach database on old sql server to be sure the new one is used

- start epo services

- on the local console of the epo server open https://eposervername:port/core/config/

- enter new database settings (name and credentials) and test connection

- restart epo services

McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 5

Re: Upgrade ePO 4.5 DB from SQL 2005 to SQL 2008

Please refer to the steps  documented in KB68427.

This article provides instructions that are useful for the following:

  • Moving the ePolicy Orchestrator (ePO) database from one SQL server to another SQL server.
  • Moving the ePO database without moving the ePO server.
  • Migrating the ePO database to a new SQL server, while keeping the same ePO server.

Re: Upgrade ePO 4.5 DB from SQL 2005 to SQL 2008

We upgraded our remote ePO database from 2005 to 2008 last week. I used this article http://  if you are ePO admin your steps will be step 1, step 6, step 7 and step 8 and the rest give to the database administrator.

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community