Suspending Updates to Databases for Copying

Adaptive Server version 12 provides the new quiesce database command to temporarily suspend updates to databases. You may want to suspend database updates to use an external database backup utility or to unmirror a disk. While the database is in the quiescent state, read transactions from the database are allowed. You can suspend and restart transactions with the quiesce database command issued from different user sessions.

If you have multiple databases on a single device, and you want to copy the entire device, you need to quiesce all the databases on the device before you perform the copy. If you have multiple devices for a single database, be sure to copy all the devices.

For more information on the quiesce database command, see the System Administration Guide for ASE 12.5.