The primary database continues running, in an exposed mode.
The primary database remains available to clients, and existing connections on a readable secondary remain usable and new connections can be made.
Suspending an Always On secondary database does not directly affect the availability of the primary database.
Miranda updating of group on server list failed
This is in contrast to database mirroring, where the mirroring state is suspended on both the mirror database and the principal database.
Suspending an Always On primary database suspends data movement on all the corresponding secondary databases, and redundancy and failover capabilities cease for that database until the primary database is resumed.
A SUSPEND command returns as soon as it has been accepted by the replica that hosts the target database, but actually suspending the database occurs asynchronously.
Updated: May 17, 2016Applies To: SQL Server 2016You can suspend an availability database in Always On Availability Groups by using SQL Server Management Studio, Transact-SQL, or Power Shell in SQL Server 2016.
Note that a suspend command needs to be issued on the server instance that hosts the database to be suspended or resumed.
The effect of a suspend command depends on whether you suspend a secondary database or a primary database, as follows: Only the local secondary database is suspended and its synchronization state becomes NOT SYNCHRONIZING. The suspended database stops receiving and applying data (log records) and begins to fall behind the primary database.Existing connections on the readable secondary remain usable.New connections to the suspended database on the readable secondary are not allowed until data movement is resumed. If you suspend each of the corresponding secondary databases, the primary database runs exposed.** Important ** While a secondary database is suspended, the send queue of the corresponding primary database will accumulate unsent transaction log records.Connections to the secondary replica return data that was available at the time the data movement was suspended.The primary database stops data movement to every connected secondary database.