If you run SQL Server on a laptop or local desktop for development / research purposes, then you'll want to turn SQL Services on and off when needed so they don't interfere with other work.
To do so, create batch files for starting and stopping the services.
The commands you want take the form >
NET START SERVICENAME
NET STOP SERVICENAME
service names are >
- MSSQLSERVER - Database Engine
- MSDTSSERVER100 - SSIS / Integration Services
- REPORTSERVER - SSRS / Reporting Services
- MSSQLSERVEROLAPSERVICE -- SSAS / Analysis Services
so , if you're really lazy, cut & paste the following into batch files >
NET START MSSQLSERVER
NET START MSDTSSERVER100
NET START REPORTSERVER
NET START MSSQLSERVEROLAPSERVICE
NET STOP MSSQLSERVER
NET STOP MSDTSSERVER100
NET STOP REPORTSERVER
NET STOP MSSQLSERVEROLAPSERVICE
No comments:
Post a Comment