Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

How to: Pause a Database Mirroring Session (Transact-SQL)

At any time, the database owner can suspend a database mirroring session, which might improve performance during bottlenecks.

To pause a database mirroring session

  1. Connect to either partner.

  2. 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.