
CHAPTER 6 Implement: Making Database Administration Changes
67
You must configure the local and remote Backup Servers at startup by
providing the appropriate values to the command line options. A remote dump
to greater than 25 stripes with the local and remote Backup Servers started with
default configuration will fail because the maximum number of network
connections that Backup Server can originate (specified by the
-N option) is by
default 25. The maximum number of server connections into the remote
Backup Server (specified by the
-C option) is 30.
Dump Format
In Backup Server 12.0 the stripe number must be stored in integer format.
Earlier versions of Backup Server stored the stripe number in the HDR1 label
in ASCII format in 4 bytes. Thus, earlier Backup Server versions will not be
able to load a dump file that uses the version 12.0 dump format. However,
Backup Server 12.0 can read and write earlier versions of the dump format.
Dump or load operations involving one or more remote servers will abort with
an error message in the following instance: if one or more remote servers uses
an earlier Backup Server version and the number of stripes to which the
database is dumped (or from which it is loaded) is greater than 32.
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 at http://manuals.sybase.com:80/onlinebooks/group-
as/asg1250e/sag/@Generic__BookView
for ASE 12.5.
Komentáře k této Příručce