Unwired Server Database File Recovery (MORecover) Utility

The MORecover utility, with adsbackup.exe, backs up Unwired Server database files while the server is running. This utility is located in <UnwiredPlatform_InstallDir>\Servers\MessagingServer\Bin.

Recent versions of the Advantage Database Server do not allow Unwired Server database files to be copied while the service is running. Stopping Unwired Server to perform regular backups is highly inconvenient in a production environment.

Prerequisite: Before executing MORecover:

Create an MORecover snapshot by running adsbackup to back up the tables required by MORecover. Use the -i (include) option to indicate the database tables to include in the backup. For an MORecover snapshot, these tables are:
- APPLICATIONS
- CFG_IDS
- CFG_PROP_VALUES
- CFG_SUBFOLDER_PROP_VALUES
- CFG_TEMPLATES
- DEVICES
- USER_DEVICE
- USERS
The source database argument for the command must be the full path of the OBR.add file in the Unwired Server data folder. The destination can be any folder. A collection of files constituting the backed-up data is created in the location you specify and stored as the MORecover backup data (see Example 1 below).
Convert the files generated by adsbackup into a standard database format. The generated files reflect the raw data from the original tables, excluding the index data. Therefore, files generated by adsbackup cannot be used directly as a database (see Example 2 below).

For information on adsbackup utility parameters and options, see Advanatage Database Server Backup (adsbackup) Utility.

Syntax

MORecover <recoveryDatabaseLocation>

Examples

Example 1: – This example uses adsbackup -i (include) to indicate the database tables to include in the MORecover snapshot.

adsbackup.exe -i APPLICATIONS,CFG_IDS,CFG_PROP_VALUES,CFG_SUBFOLDER_PROP_VALUES,CFG_TEMPLATES,DEVICES,USER_DEVICE,USERS <sourceDatabaseLocation> <destinationFileLocation>

Example 2: – Before running MORecover to restore your database, you must convert the data files created by adsbackup back to a standard database format. The following example uses the -r option to restore the backup data to a temporary folder. You can then point MORecover to the restored data in this folder.
```
adsbackup.exe -r <destinationFileLocation> <recoveryDatabaseLocation>
```

Usage

While the specified subset of tables typically results in a time-efficient backup operation, Sybase recommends that you schedule this command to run regularly during a time of light system load, since the backup operation contends with Unwired Server normal processing for database resources.