DMVs Waits Cookbook Scripts XEvents SPs Catalog Functions Errors T-SQL Arch Ops
high availability
#high-availability#remove-mirroring

Remove mirroring

This topic describes how to remove database mirroring from a database in SQL Server by using SQL Server Management Studio or Transact-SQL.

This topic describes how to remove database mirroring from a database in SQL Server by using

Management Studio or Transact-SQL. At any time, the database owner can

manually stop a database mirroring session by removing mirroring from the database.

Security

Management Studio

Transact-SQL

After Removing Database Mirroring

Requires ALTER permission on the database.

  1. During a database mirroring session, connect to the principal server instance, in Object

Explorer, click the server name to expand the server tree.

  1. Expand

, and select the database.