January 9, 2007 at 2:57 am
Hi Every one,,
There is a very easy method of stoping all the services of sql sever 2000 but after installation sql server 2005. I am not getting how to stop/Start all services of sql server 2005. for saving my computer resources....
Please share your thoughts for solving this problems..
January 9, 2007 at 11:45 am
Use SQL server conffiguration Manager or you can create a batch file using NETSTOP/NETSTART commands...
MohammedU
Microsoft SQL Server MVP
January 9, 2007 at 9:30 pm
You r right.....Mohammed uddin
but when i stop all services using conffiuration manger after that i open sql server management studio and connnect to them it connect .. what is the reason behind that.............
what is the befinit of stoping the services......
would you please explain your batch process netStart and netstop.
January 9, 2007 at 11:29 pm
If you stop the sql service in SCM, I don't think you can connect without starting sql in SSMS...
net stop sqlserveragent
net stop mssqlserver
net start mssqlserver
net start sqlserveragent
http://www.databasejournal.com/features/mssql/article.php/3644906
MohammedU
Microsoft SQL Server MVP
January 10, 2007 at 12:19 am
Thanx for your valuable
Response.......
I will check it and I hope it will definitely works......
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply