difference between pause & stop sql server

[manish2007]

How Many Differnce Between stop $ pause Sql Server service How Many Service Run On Pause Case

[debasisdas]

Your questionis too much theoritical. It is beyond the scope of this discussion to explain all that here. You need to go through some good books for the purpose or can easily find all that by investing some time in little web searching.

[manish2007]

Your questionis too much theoritical. It is beyond the scope of this discussion to explain all that here. You need to go through some good books for the purpose or can easily find all that by investing some time in little web searching.

Thanks My Search Complete and find Answer... it is complet anser ?

When you pause an instance of Microsoft® SQL Server™, users who are connected to the server can finish tasks, but new connections are not allowed. For example, you can pause an instance of SQL Server for a few minutes and send a shutdown message to connected users before shutting it down. You can also resume a SQL Server service.

You can pause an instance of SQL Server before stopping the server. Pausing an instance of SQL Server prevents new users from logging in and gives you time to send a message to current users asking them to log out before you stop the server.