Sunday, March 11, 2012

Control SQL Server Service Remotely

I want to start, pause and stop others SQL Server computer remotely from
my computer.
How to do that?
ThanksRobert
There are several ways this can be acheived and here are a just a few of the
options:
Using SQL Server Enterprise Manager Right Click on the SQL Server instance
you want to control the Service of ie. Stop | Pause | Start. To Control SQL
Server Agent, expand the Server | Management node and Right Click SQL Server
Agent.
Using the SQL Server Service Manager (sqlmangr.exe) Select the Server and
the Service you wish to control and the action to take.
Using the Services Controller (sc.exe) command line utility (replacing
\\servername with the server of the server to stop the service on and
service_name with the name of the service to stop)
sc \\servername stop service_name
sc \\servername start service_name
sc \\servername pause service_name
sc \\servername continue service_name
- Peter Ward
WARDY IT Solutions
"Robert Lie" wrote:
>
> I want to start, pause and stop others SQL Server computer remotely from
> my computer.
> How to do that?
> Thanks
>|||search key word 'remote' in books online,you will find the answer.
"Robert Lie" <robert.lie24@.gmail.com>
':uPUmuwbWFHA.1404@.TK2MSFTNGP10.phx.gbl...
>
> I want to start, pause and stop others SQL Server computer remotely from
> my computer.
> How to do that?
> Thanks

No comments:

Post a Comment