we clustered a sybase SQL 11.5 server for a customer. Now we have got a
problem with automatically starting the SQL and Backup services of the
After booting the primary Server everything looks O.K.. All services were
started and no errors where replyed in the logfile of the sybase script.
With a sybase tool it was possible to ping the sql server from a
1. The sql client userapplication founds no server, though a ping with the
sybase client tool to the server succeeds. Then we started the sybase
central application on the server and stopped the sybase sql service and the
sybase backup service and restarted FIRST the sql service and THEN the
backup service. After that the client workstation could connect with its
Why does this work ?
If we started FIRST the sybase backup service and SECOND the sybase SQL
service the client application could not connect, besides the sql server
How could we solve the problem ?
Our idea is to modify the sql sript for the Co-StandbyServer because it
looks like that the sql backup service(_BS) will be started before the SQL
service. (We have modified our script so that it will start the sql backup
service (_BS), in the original script only the SQL service will start).
2. When we stop the sybase sql backup service and the sybase sql service
over ther services from windows nt, we could not restart them over this way
! Starting and stopping the services over the sybase central application was
possible ! Why is it not possible to start the sql services over the windows
nt services (withhot Co-StandbyServer both ways are possible) ???
Subject: Sybase SQL Server 11.5 and Co-StandbyServer
Date: Mon, 2 Apr 2001 16:13:57 +0200
Organization: TargoSoft GmbH
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Xref: forums-1-dub sybase.public.sqlserver.nt:1003
Article PK: 1087610
Subject: Re: Sybase SQL Server 11.5 and Co-StandbyServer
Date: Mon, 2 Apr 2001 21:54:43 -0600
X-Newsreader: MicroPlanet Gravity v2.30
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 220.127.116.11
Xref: forums-1-dub sybase.public.sqlserver.nt:999
Article PK: 1087607
What does your SQL.INI file look like?
Jim Egan [TeamSybase]
Sybase Professional Services
Get your free subscription to PowerTimes at http://www.powertimes.com