What is the stopping mode of SQL Server? What are their differences?
The following is how SQL Server is stopped. There are probably some of the following:
1 , from SQL Server Configuration manager-->sql Server Service inside Stop SQL Server.
650) this.width=650; "title=" 1.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M02/58/2A/ Wkiol1sru6ixsc4raajuif47frq696.jpg "alt=" Wkiol1sru6ixsc4raajuif47frq696.jpg "/>
2. from SQL Server Management Studio inside Stop SQL Server
650) this.width=650; "title=" 2.JPG "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M02/58/2E/ Wkiom1sruuubtfsraahfg9gkuyy132.jpg "alt=" Wkiom1sruuubtfsraahfg9gkuyy132.jpg "/>
3. Service ( local ) inside Stop SQL Server :
650) this.width=650; "title=" 3.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M00/58/2A/ Wkiol1sru6qg7eevaakj8dkh0eo255.jpg "alt=" Wkiol1sru6qg7eevaakj8dkh0eo255.jpg "/>
4. issued "Net Stopmssqlserver" , ' Y ' Command Stop SQL Server
650) this.width=650; "title=" 4.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M00/58/2E/ Wkiom1sruuzdzv3faae3lbkc3rw365.jpg "alt=" Wkiom1sruuzdzv3faae3lbkc3rw365.jpg "/>
5. in the SQL Query Interface execution SQL statement:shutdown,
650) this.width=650; "title=" 5.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M01/58/2A/ Wkiol1sru6qri67aaajqasvfnsi237.jpg "alt=" Wkiol1sru6qri67aaajqasvfnsi237.jpg "/>
Shutdown waits for the process to complete before it stops SQL
The results of the above 5 methods are similar.
When you perform a stop mode, SQL Server makes a checkpoint for each database, writes dirty pages that are not written to disk to disk, reducing the time to recover the database after the next start of SQL Server.
6. execute the SQL statement in the SQL query interface : Shutdown with nowait
650) this.width=650; "title=" 6.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M01/58/2E/ Wkiom1sruuzwmq6maajo8rih3wc060.jpg "alt=" Wkiom1sruuzwmq6maajo8rih3wc060.jpg "/>
Shutdownwith nowait does not wait for the process to complete, but to stop directly SQL Server , SQL does not do the database Checkpoint .
7. Sqlservr.exe the SQL process to end the task from the Task Manager
650) this.width=650; "title=" 7.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M01/58/2E/ Wkiom1sruuyhs8t1aatkin2gr6s077.jpg "alt=" Wkiom1sruuyhs8t1aatkin2gr6s077.jpg "/>
this end way like a sudden power outage, SQL Server No Checkpoint may cause corruption in the database.
This article is from "What is our favorite" blog, please be sure to keep this source http://pxizhi.blog.51cto.com/5283742/1599601
How SQL Server is stopped