Pausing-Restarting SQL Server Service

Hi,
When I use NET PAUSE in cmd mode, the service pauses successfully but when I
issue NET START again, the service stays in pause state unless I use service
manager to start it.
Any help would be greatly appreciated,
LeilaYou need to use NET CONTINUE
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23eb9TK6AGHA.984@.TK2MSFTNGP12.phx.gbl...
> Hi,
> When I use NET PAUSE in cmd mode, the service pauses successfully but when
> I
> issue NET START again, the service stays in pause state unless I use
> service
> manager to start it.
> Any help would be greatly appreciated,
> Leila
>|||Thanks indeed!
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#Jdojl8AGHA.360@.TK2MSFTNGP09.phx.gbl...
> You need to use NET CONTINUE
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23eb9TK6AGHA.984@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> > When I use NET PAUSE in cmd mode, the service pauses successfully but
when
> > I
> > issue NET START again, the service stays in pause state unless I use
> > service
> > manager to start it.
> > Any help would be greatly appreciated,
> > Leila
> >
> >
>|||>Hi,
>When I use NET PAUSE in cmd mode, the service pauses successfully but when I
>issue NET START again, the service stays in pause state unless I use service
>manager to start it.
>Any help would be greatly appreciated,
>Leila
>
>
You need to use NET CONTINUE. NET START won't do anything - it's already
started.
Cheers -
Simon