Very frequently I use following command prompt script to start and stop default instance of SQL Server. Our network admin loves this commands as this is very easy.
Click Start >> Run >> type cmd to start command prompt.
Start default instance of SQL Server
net start mssqlserver
net start mssqlserver
Stop default instance of SQL Server
net stop mssqlserver
net stop mssqlserver
Start and Stop default instance of SQL Server.
You can create batch file to execute both the commands together.
You can create batch file to execute both the commands together.
No comments:
Post a Comment