How to disable database mirroring for a particular database?

Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model.  There may be a requirement to disable database mirroring for a database that is no longer required.

To achieve this, delete the ENDPOINT for the database and there is an additional step needed to remove that particular database from Database Mirroring. To perform that execute ALTER DATABASE SET PARTNER OFF. The ::= in ALTER DATABASE statement controls mirroring for a database. Values specified with the database mirroring options apply to both copies of the database and to the database mirroring session as a whole. Only one is permitted per ALTER DATABASE statement.



No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |