Wednesday, November 23, 2011

Remove 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. In the Select a Page pane, click Mirroring.

  5. To remove mirroring, click Remove Mirroring. A prompt asks for confirmation. If you click Yes, the session is stopped and mirroring is removed from the database.

    For more information about the impact of removing mirroring, see Removing Database Mirroring.

  6. Optionally, you can recover the former mirror database. On the server instance that was the mirror server, use the following Transact-SQL statement:


No comments:

Post a Comment