Post reply

Stop/Start Full Text Search, Integration Services and Reporting Services

  • July 30, 2010 at 10:15 am

    #238299

    Hi,

    I'm trying to Stop & Start the SQL Server Services Full Text Search, Integration Services and Reporting Services from Command prompt. Could you please advice me how to do that?

    I did find how to Stop & Start Database Engine, SQL Server Agent as below.

    net stop MSSQL$ instancename

    net start MSSQL$ instancename

    net stop SQLAgent$ instancename

    net start SQLAgent$ instancename

    I'm trying to create a batch file to stop and start the SQL Server Services for maintenance purpose. Please advice me the best way to achieve this

    Thanks

  • July 30, 2010 at 10:41 am

    #1200469

    Just put those commands in a notepad file and save it as .bat. You are good to go !

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • July 30, 2010 at 10:55 am

    #1200474

    Thank you Adiga,

    How to Stop & Start the SQL Server Services Full Text Search, Integration Services and Reporting Services from Command prompt?

    Thanks

  • July 30, 2010 at 10:00 pm

    #1200597

    Get the Service Name from services.msc for those services. As you did for the other services, use NET STOP servicename

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply