SQL Server Performance

Pause

Discussion in 'General DBA Questions' started by cb, Feb 7, 2003.

  1. cb New Member

    At one instance I tried to PAUSE one SQL server service for some administrative tasks. I was unable to pause, what is the reason behind this.

    I had followed as per books online for pausing sql server.

    Any help is appreciated.
  2. satya Moderator

    How did you started the SQL Server?
    Is it a service based from Control Panel --> Services or manually started from command prompt?

    Satya SKJ
  3. cb New Member

    Thank satya for quick reply.

    To explain further this server is not a production server, so I started using sqlservr from command prompt with limited options. Does this make any difference from serviced startup.

  4. bradmcgehee New Member

    If you start SQL Server from the command prompt, you cannot control it from the Services utility. You need to run it as a service in order to use Services to control its behavior.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  5. satya Moderator

    There you are!, u cannot pause the service if its started from command prompt. Only if the MSSQLServer service has been started from Control Panel --> services you can achieve the thing.

    Restart the services as specified and you will see the difference.



    Satya SKJ
  6. cb New Member

    Thanks for both of you for quick replies.

    Unlike NET START .. are they any command to pause the server, I need to control the server from a code.

  7. satya Moderator

    NET PAUSE.... NET CONTINUE, do refer to books online updated SP3.

    Satya SKJ

Share This Page