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.

The Advantage Database Server allows an online backup while the server is running. Online Backup (or "hot" backup) functionality allows you to capture and save a snapshot of your database. If users currently have tables opened and are making changes, the resulting backup image will not include their new modifications, it will only include the data as it existed when the snapshot was taken. See: http://devzone.advantagedatabase.com/dz/WebHelp/Advantage10.1/index.html?master_online_backup.htm.

Prerequisite: Before executing MORecover:

Create an MORecover snapshot by running adsbackup to back up the tables required by MORecover. Sybase recommnends backing up all tables, but you can use the -i (include) option to indicate the specific database tables to include in the backup.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 Advantage Database Server Backup (adsbackup) Utility.

Syntax

MORecover <recoveryDatabaseLocation>

Examples

Example 1: – This example uses adsbackup to include all database tables in the MORecover snapshot.
```
adsbackup.exe <sourceDatabaseLocation> <destinationFileLocation>
```
Example 2: – This example uses adsbackup -i (include) to indicate the database tables to include in the MORecover snapshot.
```
adsbackup.exe -i CFG_IDS,CFG_PROP_VALUES,CFG_SUBFOLDER_PROP_VALUES,CFG_TEMPLATES,DEVICES,USER_DEVICE,USERS <sourceDatabaseLocation> <destinationFileLocation>
```
Example 3: – 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.