Abstract FileReplicationPro (FRP) can be used to backup your SQL Server databases. The replication procedure is not as straight forward as replicating other files due to file locking constraints by SQL server. A backup and restore procedure can be implemented as follows: 1. Use SQL Server to create a database backup file. 2. Replicate the database backup file using FRP. 3. Restore the database backup file using FRP. 4. Use SQL Server to re-create the database from the database backup file. The procedures for creating a database backup file and for restoring the database from the database backup file are almost identical. The only difference is the script written to the step commands window (See step 5 of the Backup/Restore Procedure). This document describes how to perform a backup or restore of your SQL server database.

Backup/Restore Procedure 1. Start an instance of Enterprise Manager, and navigate to the following location of the server in the left task pane of Enterprise manager (see below). Microsoft SQL Servers SQL Server Group (Local) (Windows NT) Management Jobs (See Figure 1). Please note that depending on your servers particular configuration the section “(Local) (Windows NT)” may differ from what is shown.