Resetting Location Logging

Whenever a new location is created, the logging system automatically creates a series of log files just for that location. For an existing location, we recommend that these location log files be manually reset after each location backup process. Manually resetting location logging immediately after backing up speeds recovery in the event of a serious media failure, since only log entries originating after your location backup need be replayed against your location tables.

The XDB Server logging system automatically creates a series of log files when a new location is created. Logging should be manually reset as a part of the location backup process.

To manually reset location logging:

  1. Shut down server.
  2. Copy log files from the location logging directory to a separate archive directory.
  3. Depending on whether you are using the BACKUP LOCATION command or an operating system backup command, do one of the following:
    • Bring the server back up and run the BACKUP LOCATION command from the SQL Wizard. (Be sure you execute the BACKUP LOCATION command from a location other than the one you are backing up.)
    • Run your operating system (or other) backup utility as appropriate (be sure to archive all directories associated with the XDB location).
  4. Shut down the server (if using BACKUP LOCATION).
  5. Delete all log files (*.log) from your location logging directory. The next time the location is accessed, a fresh series of log files will automatically be created by the logging system.

Location logging should be manually reset after any type of location backup (that is BACKUP LOCATION command or operating system backup).