Startup & Shutdown Sybase server

rameznabil

unread,

May 14, 2008, 10:12:11 AM5/14/08

to

Hi,
I wanna know how to startup and shutdown sybase server from
(command prompt)

Thanks in advance

HarryLai

unread,

May 14, 2008, 10:36:07 AM5/14/08

to

If Windows server, simply to use "net start <Service_Name>" and "net stop <Service_Name>" to start and stop service for Sybase.

<Ramez Nabil> 撰寫於郵件新聞:482af33b.42d...@sybase.com...

HarryLai

unread,

May 14, 2008, 10:41:12 AM5/14/08

to

btw, use "net stop <Sybase_Name>" is equal to "shutdown with nowait", if you want to shutdown normally, use batch and script file to
do it;

in batch.bat:
isql -U<sa> -P<password> -S<server_name> -i<script_file>

in script.sql:
shutdown

HTH

"HarryLai" <nospam_...@bigfoot.com> 撰寫於郵件新聞:482af8d7@forums-1-dub...

rameznabil

unread,

May 15, 2008, 4:03:21 AM5/15/08

to

Dear HarryLai
Thanks for your concern, I'd try to use net stop and net
start, But they didn't work and i got the following error:
The service name is invalid.
More help is available by typing NET HELPMSG 2185.

But i'd also tried another way to start the server by using
the Following command:
sqlsrvr.exe -sServer_Name

And it was perfect ..
For shutdown, i connect to sybase through (isql) then issue
Shutdown command.
Thank you again

> btw, use "net stop <Sybase_Name>" is equal to "shutdown
> with nowait", if you want to shutdown normally, use batch
> and script file to do it;
>
> in batch.bat:
> isql -U<sa> -P<password> -S<server_name> -i<script_file>
>
> in script.sql:
> shutdown
>
> HTH
>
>
> "HarryLai" <nospam_...@bigfoot.com>
> >

¼¶¼g©ó¶l¥ó·s»D:482af8d7@forums-1-dub...

If Windows
> server, simply to use "net start <Service_Name>" and "net
> stop <Service_Name>" to start and stop service for Sybase.
> > >
> > <Ramez Nabil>
>

¼¶¼g©ó¶l¥ó·s»D:482af33b.42d...@sybase.com...

HarryLai

unread,

May 15, 2008, 10:06:57 AM5/15/08

to

Thanks Ramez for remind, basically I forgot to use sqlsrvr.exe to start the server : )

<Ramez Nabil> ???????:482bee49.61c...@sybase.com...

Dear HarryLai
Thanks for your concern, I'd try to use net stop and net
start, But they didn't work and i got the following error:
The service name is invalid.
More help is available by typing NET HELPMSG 2185.

But i'd also tried another way to start the server by using
the Following command:
sqlsrvr.exe -sServer_Name

And it was perfect ..
For shutdown, i connect to sybase through (isql) then issue
Shutdown command.
Thank you again

> btw, use "net stop <Sybase_Name>" is equal to "shutdown
> with nowait", if you want to shutdown normally, use batch
> and script file to do it;
>
> in batch.bat:
> isql -U<sa> -P<password> -S<server_name> -i<script_file>
>
> in script.sql:
> shutdown
>
> HTH
>
>
> "HarryLai" <nospam_...@bigfoot.com>
> >

撰寫於郵件新聞:482af8d7@forums-1-dub...

If Windows
> server, simply to use "net start <Service_Name>" and "net
> stop <Service_Name>" to start and stop service for Sybase.
> > >
> > <Ramez Nabil>
>

撰寫於郵件新聞:482af33b.42d...@sybase.com...

Sherlock, Kevin

unread,

May 15, 2008, 10:12:24 AM5/15/08

to

Don't forget that with windoze, using sqlsrv.exe to start your server means
that you have to keep that command window open (minimized if you want) in
order for the server to stay up and running. Once the command window is
closed, your server will shutdown. That's the whole reason for the service.
Why not just stop/start the service like you would with any other windoze
service? Just get the service name correct, and log in with the correct
account and it should work with net start / net stop.

"HarryLai" <nospam_...@bigfoot.com> wrote in message
news:482c4381@forums-1-dub...

rameznabil

unread,

May 21, 2008, 8:18:20 AM5/21/08

to

Dear Kevin
Thank you ...

Best regards
Ramez Nabil

> > If Windows
> >> server, simply to use "net start <Service_Name>" and
> "net >> stop <Service_Name>" to start and stop service for
> Sybase. >> > >
> >> > <Ramez Nabil>
> >>
> >