Start and Stop Servers

Start and stop Adaptive Server and Backup Server after a shutdown for database maintenance, because of an operating system failure, or for other reasons.

XP Server is not started by the installation process. XP Server is started only when any XP command is issued through isql.

You can use Sybase Control Center to start and stop servers manually or automatically. The ASE plug-in can also start Adaptive Servers monitored by Unified Agent if the agent is properly configured.

The installation program creates the sql.ini file and system environment variables when you install servers on your computer.

• Server Start-up Parameters
  Adaptive Server and Backup Server store their default start-up parameters in the Windows Registry file. This allows you to start and manage servers as Windows services, and allows servers to start automatically when you start your computer.
• Starting and Stopping Servers Using Unified Agent
  You can start and shut down local or remote Adaptive Servers running if you have the proper permission to do so.
• Start and Stop Servers Using the Control Panel
  You can start, stop, and pause a server both automatically and manually from the Services applet in the Control Panel.
• 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.
• Stopping Adaptive Server
  Only the system administrator can issue a shutdown command. Using a shutdown command minimizes the amount of work that automatic recovery needs to do when the servers are restarted. The preferred method of stopping Adaptive Server is to use the Transact-SQL shutdown command.