Progress Fathom Replication
User’s Guide


Restoring source and target databases

A database that is enabled for Fathom Replication cannot be restored unless Fathom Replication is first disabled.

To restore a database that is enabled as a source database:

  1. Disable Fathom Replication on the source database with the following command:
  2. PROUTIL source_db_name -C DisableSiteReplication source 
    

  3. Restore your source database with the following command:
  4. PROREST source_db_name {( file | device )} 
    

    Be sure you delete the database.repl.recovery file any time you restore.

    If the database you are restoring was previously enabled for Fathom Replication, after the restore, it is again enabled for Fathom Replication. Fathom Replication cannot be restarted for this database until Fathom Replication is disabled and then re-enabled. The target database must be resourced after the restore, disable, and enable have been performed.

    Note: A database enabled as a target database can be restored once Fathom Replication has been disabled. This is not a recommended practice, however, because the target database should always be created from a source database, not a backup of itself. If something happens to your target database, and you need a new copy of it, take the latest backup of your source database. This guarantees that they can be synchronized. The latest backup of your source database can be from a full online backup or a full offline backup. It cannot be an incremental backup. Be sure to delete the recovery file before restarting Fathom Replication.

    Once a database is enabled for Fathom Replication, information about the state of Fathom Replication is kept in the database itself. This information is not restored when the database is restored. The only way to recover this information is to re-enable the database for Fathom Replication.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095