Pausing and continuing SQL Server v7.0
In the SQL Service Manager utility, you will find an option for pausing SQL
Server. At first glance, you may be asking how could this be useful. Pausing SQL
Server assists in controlling additional user access. This is usually necessary
on the way to a SQL Server shutdown.
�
When SQL Server is executing in its normal state, users can connect as
necessary, but when the server is "Paused," the system disallows new
connections while letting existing connections continue to work.
�
If the server is to be "Continued," the system then returns to its
normal state and will let users connect as necessary. You can use this
"step down" method to bring down SQL Server gracefully, both to the
server and your users.
�
You can also control the SQL Server through other mechanisms. From a command
line, enter any of the following:
�
net pause mssqlserver
�
net continue mssqlserver
�
net stop mssqlserver
�
net start mssqlserver
Home��Previous��Next