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.

See Also

Tasks

Resume a Database Mirroring Session (Transact-SQL)

Reference

ALTER DATABASE (Transact-SQL)

Concepts

Database Mirroring Administration

Pausing and Resuming Database Mirroring (SQL Server)

Other Resources

Database Mirroring Administration How-to Topics (Database Engine)