Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase SQL Server 11.5 and Co-StandbyServer

2 posts in Windows NT Last posting was on 2001-04-03 03:54:43.0Z
Thorsten Witt Posted on 2001-04-02 14:13:57.0Z
From: "Thorsten Witt" <witt@targosoft.de>
Subject: Sybase SQL Server 11.5 and Co-StandbyServer
Date: Mon, 2 Apr 2001 16:13:57 +0200
Lines: 40
Organization: TargoSoft GmbH
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <sn67CH4uAHA.247@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 62.145.8.2
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1003
Article PK: 1087610

Hi,

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
Sybase Server.

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
workstation.

Problems:
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
application !
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
ping succeeds.

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) ???

Thorsten Witt


Jim Egan Posted on 2001-04-03 03:54:43.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: Sybase SQL Server 11.5 and Co-StandbyServer
Date: Mon, 2 Apr 2001 21:54:43 -0600
Message-ID: <MPG.1532f77065b222bd98b23d@forums.sybase.com>
References: <sn67CH4uAHA.247@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 5
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:999
Article PK: 1087607

What does your SQL.INI file look like?
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com