13.6 Removing database Mirroring

13.6 Removing database Mirroring

13.6.1 pausing, continuing database mirroring

In the main interface of the database mirroring configuration, click the Pause button to prepare to pause mirroring this database.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6D/C8/wKioL1VsB8DBFtBSAAL7u3JB7Js756.jpg "style=" float: none; "title=" Database property mirroring. png "alt=" wkiol1vsb8dbftbsaal7u3jb7js756.jpg "/>

Determine if you want to pause mirroring this database.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6D/CD/wKiom1VsBirjDnbbAAB1VmMhi_M939.jpg "style=" float: none; "title=" Pause 1.png "alt=" Wkiom1vsbirjdnbbaab1vmmhi_m939.jpg "/>

After pausing, the principal database state is "principal, Pending," and the mirror database status is "mirrored, pending/restoring ...".

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6D/C8/wKioL1VsB8aiF0teAANjrvANU-8190.jpg "style=" float: none; "title=" Pause 2.png "alt=" Wkiol1vsb8aif0teaanjrvanu-8190.jpg "/>

In the main interface of the database mirroring configuration, click the Continue button to continue mirroring this database.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6D/C8/wKioL1VsCIuhma1oAAMGRYhOax4981.jpg "title=" continue. png "alt=" Wkiol1vsciuhma1oaamgryhoax4981.jpg "/>

13.6.2 Removing Database Mirroring

In the database mirroring configuration of the main interface, click the "Cancel Mirroring" button to prepare to cancel mirroring this database.

This article from "SQLServer2014 series" blog, declined reprint!

13.6 Removing database Mirroring