Stopping Backup Server

To shut down a Backup Server:

  1. Use isql to log in to a server with System Administrator privileges:

    isql -Usa -Ppassword -Sserver_name
  2. Enter the following command to shut down the specified Backup Server:

    1> shutdown SYB_BACKUP
    2> go

After you shut down a Backup Server, you must wait at least 30 seconds before restarting it.

Issuing the shutdown command prints a message similar to the following to the stderr file:

Backup Server: The Backup Server will go down immediately. 
Terminating sessions.

This is normal behavior. If a message indicates that Adaptive Server or Backup Server is waiting for processes to complete, and you need to stop Adaptive Server or Backup Server immediately, you can use the shutdown with nowait command. shutdown with nowait does not wait for currently executing statements to finish and does not perform checkpoints in every database.

Using shutdown with nowait for Backup Server can cause inconsistent or incomplete dumps and loads. Use this command only when necessary.

For more information on the shutdown command, see the Adaptive Server Reference Manual.