Recovery with Incremental Backups Example

The following sequence of events shows the typical steps in performing incremental backups and subsequently recovering from a media failure:

1. On Friday afternoon perform a standard backup using the following command:

   BACKUP LOCATION MYLOC TO D:\BACKUPLOCS

2. On Monday afternoon perform an incremental backup using the following command:

   BACKUP LOCATION MYLOC TO D:\BACKUPLOCS INCREMENTAL

   This creates directory xdb20051015153015000002, for instance.

3. On Tuesday afternoon perform an incremental backup using the following command:

   BACKUP LOCATION MYLOC TO D:\BACKUPLOCS INCREMENTAL

   This creates directory xdb20051016144416000003, for instance.

4. On Wednesday morning recover from a media failure using the following steps:
   1. Stop the XDB Server.
   2. Copy the contents of the current logs to another directory, such as d:\currlocs.
   3. Remove the contents of the original XDB location.
   4. Run the xdbdata.bat script in Friday afternoon’s d:\backuplocs subdirectory.
   5. Start the XDB Server in exclusive use mode.
   6. Issue the following ROLLFORWARD commands:

      ROLLFORWARD MYLOC USING D:\BACKUPLOCS\XDB20051015153015000002
      ROLLFORWARD MYLOC USING D:\BACKUPLOCS\XDB20051016144416000003
      ROLLFORWARD MYLOC USING D:\CURRLOGS

   7. Stop the XDB Server.
   8. Restart the XDB Server for general availability.