To duplicate or copy databases, use quiesce database with the extension for creating the manifest file. quiesce database affects the quiesce hold by blocking writes in the database, then creates the manifest file. The command then returns control of the database to the user.
You cannot create a manifest file if the set of databases that are quiesced contain references to databases outside of the set. You may use the override option to bypass this restriction.
Next, use a utility to copy the database to another Adaptive Server. You must follow these rules for quiesce database hold for the copy operation:
The copy operation cannot begin until the quiesce database hold process has completed.
Every device for every database in the quiesce database command must be copied.
The copy process must complete before you invoke quiesce database release.
See quiesce database in the Reference Manual: Commands.
