MS SQL server shutdown

MS SQL server shutdown

   You may come across the situation where you would not be able to stop the MS SQL service.

I came across very interesting query which can shutdown MS SQL server immediately without waiting for other processes.

Below query runs inside the query analyser of your ms sql server

 

SHUTDOWN WITH NOWAIT; 

 
 
 
Stop using command line  

Run => CMD

net stop mssqlserver

This will stop instance of MS SQL server

To start use:

net start mssqlserver

This will start ms SQL server
 Afterrestarting the server you may see data base in suspect mode if there exists uncommited transaction.
To bring database online you may require to perform these steps

Bring database online

Don't warry you can recover file from .mdf even if you don't have .ldf file. 

MS SQL SERVER CONFIGURATION MANAGER

You can open ms sql server configuration manager as shown in below fig.  

         Open SQL Server Configuration Manager. Here you can see various sql related services.
 Note: Look at the services which you are not using and stop them to avoid unnecessary cpu and memory consumtions.

 

The services like

1. SQL Server Integration Services (SSIS)
2. SQL Server Analysis Services (SSAS)
3. SQL Server Reporting Services (SSRS)

We rarely use those services as far as development is concerned. Stop them to gain performance of your server.

Satalaj.

 

Tags:

MS SQL server shutdowngodaddy hosting MS SQL server configurationMS SQL server service packMS SQL server mirroring remove end points master keyMS SQL server Transaction commit rollbackMS SQL server 2005 attach databse without ldf filesql server default portsbackup sql databasesql server agent backupConnection Poolingsql server free space

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.