When the SQL Server runs out of disk space, move the ePO physical database files to another location on the same server as follows:
- Click Start, Run, type services.msc, and click OK.
- Right-click the following services and select Stop:
McAfee ePolicy Orchestrator Application Server
McAfee ePolicy Orchestrator Server
McAfee ePolicy Orchestrator Event Parser
- Back up the ePO database on the existing SQL Server. For details, see KB52126.
- Detach the ePO database:
- Open SQL Server Management Studio.
- Right-click the database and click Tasks, Detach.
- Click OK on the Detach Database page.
- Move the database files to the new location.
Example: Change
From: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
To: G:\MSSQL\Data
- Add the MSSQL NT Service Account to the Database files:
- Right-click on the Database file, and click Properties, Security, Edit, Add.
- Change locations to the local computer name.
- In the text box, type NT Service\MSSQL$,
- Click OK, and then click OK again.
- Repeat the same steps for all MDFs and LDFs that have been copied across.
- Reattach the database:
- Open SQL Server Management Studio.
- Right-click the Databases entry and select Attach.
- Click Add on the Attach Databases page, and then navigate to the database file in the location.
- Click Start, Run, type services.msc, and click OK.
- Right-click the following services and click Start:
McAfee ePolicy Orchestrator Application Server
McAfee ePolicy Orchestrator Server
McAfee ePolicy Orchestrator Event Parser
- Close the services window.