stopping the DB process?

[dbrowneARL]

we have the Adaptive Server Anywhere running for one of our main programs. In order to back up the database, the Adaptive server needs to be stopped. Can this be accomplished by issuing a command to it using a batch file, or in some other automated way? Ideally, we want a batch file that will stop the server, copy the database to a shared folder on our backup server, and then start the database up again. Is this possible?

 

[hobbitmaster]

Hi, stopping a sybase server can be achieved by making a batch file calling a sql script that is executed using isql. something like

isql -Uuser -Ppassword - Sserver -imyscript.sql

myscript contains then something like;

shutdown
go

for starting the server again one can call the start server batchfile.

However making a backup of your database can be achieved by dumping it using the 'dump database' command. This can be done while the server is running.

good luck.