Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
At any time, the database owner can suspend a database mirroring session, which might improve performance during bottlenecks.
To pause a database mirroring session
Connect to either partner.
Issue the following Transact-SQL statement:
ALTER DATABASE <database_name> SET PARTNER SUSPEND
where <database_name> is the mirrored database whose session you want to you want to suspend.
This statement places the database in a SUSPENDED state.
See Also
Tasks
How to: Resume a Database Mirroring Session (Transact-SQL)
Concepts
Pausing and Resuming Database Mirroring
Other Resources
ALTER DATABASE (Transact-SQL)
Database Mirroring
Database Mirroring How-to Topics