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