Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

To remove database mirroring, use the Database Properties. use the Mirroring page of the Database Properties dialog box.

Important noteImportant

Before mirroring can be reestablished, at least one log backup must be taken on the principal database and applied to the mirror database. Furthermore, any additional log backups taken since mirroring was removed must also be applied to the mirror database.

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

    RESTORE DATABASE <database_name> WITH RECOVERY;
    
    Important noteImportant

    If you recover this database, two divergent databases that have the same name are online. Therefore, you must make sure that clients can access only one of them, typically the most recent principal database.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.