Skip navigation FileNET logo
  Help for Backup and Restore  
  Search  |  Index  
Backup and restore guidelines
Concepts
What to back up
Prepare backup tapes
Backing up the system state
Backing up Process Engine
Backing up Process Analyzer
Backing up databases
Restoring the system state
Restoring Process Analyzer
Restoring databases
   

Restoring damaged databases

When restoring your workflow database, you must use the utility that corresponds to the utility you used to back up the database. The following procedure uses SQL Server as an example. For more precise details, see the help text provided with SQL Server's backup utility. If your database uses an Oracle database, see the Oracle documentation for database backup and restore procedures.

TIP SQL Server enables you to restore (or replicate) a database to a foreign server by setting up and using a backup device on that server. You may want to restore a database to a foreign server if only a few records in the database have been corrupted and/or your site cannot afford the downtime necessary to perform a database restore. Restore the database to the foreign server and copy the corrupted records to the production database.

To restore a database to a particular point in time

Use the point-in-time restore option and specify a specific time.

To restore a database to the time of failure

  1. Start the SQL Server Enterprise Manager.
  2. Back up the current transaction log.
  3. Stop all processes running on the corrupted database.

    NOTE Notify the process owners before shutting down the database.

  4. Take the database off-line.
  5. Restore the database from the database backup sets. The SQL Enterprise Manager selects all backup sets automatically. If you are using T-SQL commands to restore the database manually, restore backup sets in this order:
    1. Latest complete database backup set.
    2. Latest differential database backup set.
    3. All transaction log backup sets created after the latest differential set, or the latest complete set if there are no differential sets.
  6. If your database resides on multiple Process Engines, run the vwverify utility after restoring the database files.