To shut down a Backup Server:
Use isql to log in to a server with System Administrator privileges:
isql -Usa -Ppassword -Sserver_name
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: 126.96.36.199: 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 Reference Manual.
To stop a Backup Server that is not configured as the logical Backup Server (SYB_BACKUP) for Adaptive Server:
Change the logical Backup Server, SYB_BACKUP, to a different physical server:
1> sp_addserver SYB_BACKUP, NULL, common_name 2> go
where common_name is the name of the server in the interfaces (sql.ini on Windows) file.
Perform the steps above to stop the server.