Thursday, May 14, 2009

Running SQL Server locally

An update on a previous post.
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: