Backing up ePolicy Orchestrator databases regularly
McAfee recommends that you back up ePolicy Orchestrator databases regularly to protect your
data and guard against hardware and software failure. You may need to restore from a backup,
such as if you ever need to reinstall the server.
How often you backup depends on how much of your data you are willing to lose. At a minimum,
back up your database once a week, but you might want to backup daily if you have been
making lots of changes to your deployment. You could also do daily backups as part of an
automated nightly job. You can also spread the work by doing incremental daily backups and
then a full weekly backup each week. Save the backup copy to a different server than the one
hosting your live database--if your database server crashes you don’t want to lose your backup
too.
The process varies depending on whether you are backing up a SQL or MSDE database. To
back up a SQL Server database, see your SQL Server documentation.
Tasks
Backing up a SQL database--see your SQL documentation
Backing up an MSDE database
Backing up a SQL database--see your SQL documentation
If you are using Microsoft SQL Server or SQL 2005 Express as the database, see the SQL Server
product documentation.
Backing up an MSDE database
If you are using Microsoft Data Engine (MSDE) as the ePolicy Orchestrator database, you can
use the Database Backup Utility (DBBAK.EXE) to back up and restore ePolicy Orchestrator MSDE
databases on the database server.
TIP:
The database backup utility works while the server service is running. However, McAfee
recommends stopping the server service before beginning the backup.
You can back up and restore MSDE databases to the same path on the same database server
using this utility. You cannot use it to change the location of the database
Task
1
Stop the McAfee ePolicy Orchestrator 4.0 Server service and ensure that the SQL
Server (MSSQLSERVER) service is running. For instructions, see the operating system
product documentation.
2
Close ePolicy Orchestrator.
3
Start the Database Backup Utility (DBBAK.EXE). The default location is:
C:\PROGRAM FILES\MCAFEE\EPO
4
Type the Database Server Name.
5
Type the Database Name.
6
Select NT Authentication or SQL Account.
If you selected SQL Account, type a user Name and Password for this database.
7
Type the Backup File path.
Appendix: Maintaining ePolicy Orchestrator databases
Backing up ePolicy Orchestrator databases regularly
McAfee ePolicy Orchestrator 4.0.2 Product Guide
216
