Arun Sirpal demonstrates what the Pause option does on a SQL Server:
As stated via official Microsoft documentation “Pausing the Database Engine service prevents new users from connecting to the Database Engine, but users who are already connected can continue to work until their connections are broken. Use pause when you want to wait for users to complete work before you stop the service. This enables them to complete transactions that are in progress”.
Very handy! Let’s see it in action and compare it to a STOP.
Read on for more.