Installation guide

Migrating Existing Databases to SQL Server 2000
102 ePolicy Orchestrator
™
software version 3.0
Backing up ePolicy Orchestrator 3.0 databases (SQL Server 7
users)
Now that you have stopped the ePolicy Orchestrator server service, you are ready
to back up the ePolicy Orchestrator 3.0 databases. It is important to back up the
database should you need to continue using SQL Server 7 with Service Pack 3. Be
sure to store the backup copy of the database files (for example,
EPO_<SERVER>.MDF
and
EPO_<SERVER>.LDF) in a safe and secure location.
1 Start SQL Server 7 Enterprise Manager.
2 In the console tree under Microsoft SQL Servers | SQL Server Group, select the
SQL server where the ePolicy Orchestrator database resides. If the server
doesn't appear in the console tree, you must register it.
To register a SQL server, right-click
SQL Server Group, then select New SQL
Server Registration
. Specify the desired SQL server, authentication method,
and SQL Server group.
3 In the console tree under the desired SQL server | Databases, right-click the
desired ePolicy Orchestrator database (for example,
EPO_<SERVER>), then
select
All Tasks | Backup Database. The SQL Server Backup dialog box appears.
4 On the General tab, verify that the name of the ePolicy Orchestrator database
appears in
Database.
5 Under Backup, select Database - complete.
6 Under Destination, click Add to open the Select Backup Destination dialog box.
7 Select File name, then type the desired path or click the browse button to select
a directory.
8 Under Overwrite, select Append to media.
9 Click the Options tab, then select Verify backup upon completion.
10 Click OK to save the current entries and close the SQL Server Backup dialog
box.