Third-Party Products

SAP Sybase IQ supports backup and restore operations with third-party products that support SAP Sybase databases.

To perform a backup or restore with a third-party product, issue the BACKUP DATABASE or RESTORE DATABASE statement as if you were using SAP Sybase IQ to perform the operation, with the following exceptions:

For each archive_device, instead of specifying the actual device name, specify a string in the following format:
```
dll_name::vendor_specific_information
```
Do not specify the STACKER or SIZE parameters.

The dll_name corresponds to a dynamic link library loaded at run time. The dll_name can be from 1 to 30 bytes long, and can contain only alphanumeric and underscore characters. It must be the same for each archive_device.

vendor_specific_information varies by product, and can differ for each archive_device. The total string (including dll_name:: vendor_specific_information) can be up to 255 bytes long.

BACKUP DATABASE automatically passes vendor information to the third-party program. When you request a third-party backup, BACKUP DATABASE writes this information in the backup header file, and moves the header file on the first tape or disk file actually created for each archive_device.

Note: See the Release Bulletin for additional usage instructions or restrictions. Before using any third-party product to back up your database, make sure it is certified with SAP Sybase IQ. See the SAP Sybase Certification Reports for the SAP Sybase IQ product in Technical Documents.