Recovery with Standard Backups Example

The following sequence of events shows the typical steps in performing standard 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 a standard backup using the following command:

   BACKUP LOCATION MYLOC TO D:\BACKUPLOCS

3. On Tuesday afternoon perform a standard backup using the following command:

   BACKUP LOCATION MYLOC TO D:\BACKUPLOCS

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 Tuesday afternoon’s d:\backuplocs subdirectory.
   5. Start the XDB Server in exclusive use mode.
   6. Issue the following ROLLFORWARD command:

      ROLLFORWARD MYLOC USING D:\CURRLOGS

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