Stopping Backup Server

Only the system administrator has permission to issue a shutdown command. Using a shutdown command minimizes the amount of work for automatic recovery when the servers are restarted. The preferred method of stopping Backup Server is to use the Transact-SQL shutdown command.

  1. Log in to a server with system administrator privileges:
    isql -Usa -Ppassword -Sserver_name
  2. Enter:
    1> shutdown SYB_BACKUP
    2> go

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

A message similar to this prints to the stderr file:
Backup Server: 3.48.1.1: The Backup Server will go down immediately. 
 Terminating sessions.

This is normal behavior. If a message indicates that SAP ASE or Backup Server is waiting for processes to complete, and you must stop SAP ASE 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 may cause inconsistent or incomplete dumps and loads. Use this command only when necessary.

For more information on the shutdown command, see the Reference Manual: Commands.