Share via


How to: Pause or Resume a Database Mirroring Session (SQL Server Management Studio)

To pause or resume a database mirroring session use the Database Properties Mirroring page.

Important

Following a forced service, when the original principal server reconnects mirroring is suspended. Resuming mirroring in this situation could possibly cause data loss on the original principal server. For information about managing the potential data loss, see Forced Service (with Possible Data Loss).

To pause or resume database mirroring

  1. During a database mirroring session, connect to the principal server instance, in Object Explorer, click the server name to expand the server tree.

  2. Expand Databases, and select the database.

  3. Right-click the database, select Tasks, and then click Mirror. This opens the Mirroring page of the Database Properties dialog box.

  4. To pause the session, click Pause.

    A prompt asks for confirmation; if you click Yes, the session is paused, and the button changes to Resume.

    For more information about the impact of pausing a session, see Pausing and Resuming Database Mirroring.

  5. To resume the session, click Resume.

See Also

Tasks

How to: Remove Database Mirroring (SQL Server Management Studio)

Concepts

Pausing and Resuming Database Mirroring

Other Resources

Database Mirroring

Help and Information

Getting SQL Server 2005 Assistance