Stopping backup server – Sybase DC35823-01-1500-04 User Manual

Page 41

Advertising
background image

CHAPTER 2 Starting and Stopping Servers

Configuration Guide

25

2

Enter:

1> shutdown

2> go

The default for

shutdown

uses the

with wait

option

,

which allows Adaptive

Server to finish executing SQL statements or procedures, perform a checkpoint
in each database, disable new logins, and perform other shutdown tasks.

Issuing the

shutdown

command prints a message like this to the sterr file:

Server SHUTDOWN by request.The SQL Server is terminating

this process.

CT-LIBRARY error:

This is normal behavior. If the message indicates that Adaptive Server is
waiting for processes to complete, and you must stop Adaptive Server
immediately, you can use

shutdown with nowait

which neither waist for

currently executing statements to finish, nor performs checkpoints in every
database.

Note

Using the

shutdown with nowait

command is not recommended; use it

only when necessary.

Stopping Backup Server

To shut down a Backup Server:

1

Use

isql

to log in to a server with System Administrator privileges.

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.

Issuing the

shutdown

command prints a message similar to the following to the

stderr file:

Backup Server: 3.48.1.1: The Backup Server will go down

immediately.

Terminating sessions.

Advertising