July 30, 2010 at 10:15 am
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
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
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
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