Installation guide

Installation Guide 101
Migrating Existing Databases to SQL Server 2000
Backing up ePolicy Orchestrator 3.0 databases (MSDE users)
Now that you have installed the SQL Server 2000 Client Tools, 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 Microsoft Data Engine (MSDE). 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 2000 Enterprise Manager.
2 In the console tree under Microsoft SQL Servers, right-click SQL Server Group,
then select
New SQL Server Registration.
3 Specify the desired SQL server, use the SQL Server authentication method,
type the logon name (sa is the default) and password (blank is the default), and
select a SQL Server group.
4 In the console tree under the SQL server you just registered | 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.
5 On the General tab, verify that the name of the ePolicy Orchestrator database
appears in
Database.
6 Under Backup, select Database - complete.
7 Under Destination, click Add to open the Select Backup Destination dialog box.
8 Select File name, then type the desired path or click the browse button to select
a directory.
9 Under Overwrite, select Append to media.
10 Click the Options tab, then select Verify backup upon completion.
11 Click OK to save the current entries and close the SQL Server Backup dialog
box.