Loading...

Knowledge Center


How to move the ePO physical database files to another location on the same server
Technical Articles ID:   KB71055
Last Modified:  7/9/2018
Rated:


Environment

McAfee ePolicy Orchestrator (ePO) 5.x, 4.x

Summary

When the SQL server runs out of disk space, move the ePO physical database files to another location on the same server as follows:
  1. Click Start, Run, type services.msc, and click OK.
  2. Right-click the following services and select Stop:

    McAfee ePolicy Orchestrator Application Server
    McAfee ePolicy Orchestrator Server
    McAfee ePolicy Orchestrator Event Parser

     
  3. Back up the ePO database on the existing SQL server using one of the following articles:

    KB59562 - How to back up the ePO databases using OSQL commands
    KB52126 - How to back up and restore the ePO database using SQL Server Management Studio
     
  4. Detach the ePO database:
    1. Open SQL Server Management Studio.
    2. Right-click the database and click TasksDetach.
    3. Click OK on the Detach Database page.
       
  5. Move the database files to the new location.

    Example: 

    From: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data 
    To: G:\MSSQL\Data
     
  6. Re-attach the database:
    1. Open SQL Server Management Studio.
    2. Right-click the Databases entry and select Attach.
    3. Click Add on the Attach Databases page and navigate to the database file in the location.
       
  7. Click Start, Run, type services.msc, and click OK.
  8. Right-click the following services and select Start:

    McAfee ePolicy Orchestrator Application Server
    McAfee ePolicy Orchestrator Server
    McAfee ePolicy Orchestrator Event Parser

Rate this document

Beta Translate with

Select a desired language below to translate this page.

Languages:

This article is available in the following languages:

English United States
Japanese

Glossary of Technical Terms


 Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.