Explain how to disable database mirroring for a particular database

Next>>         SQL Server tutorial  

SQL Server - how to disable database mirroring for a particular database - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

Explain how to disable database mirroring for a particular database.

The database owner can manually stop a database mirroring session by removing mirroring from the particular database. Steps to do so:

• Connect to the Server instance
• Execute the statement ALTER DATABASE DbName SET PARTNER OFF

SQL Server - how to disable database mirroring for a particular database - May 05, 2009 at 22:00 PM by Rajmeet Ghai

Explain how to disable database mirroring for a particular database.

Mirroring helps to increase database availability. In situations where mirroring needs to be disabled, ENDPOINT of the database should be deleted. Apart from this, the syntax below should be executed:

ALTER DATABASE SET PARTNER OFF

Using this, both copies of the database and the mirroring session are applied to.

SQL Server - how to disable database mirroring for a particular database - June 09, 2009 at 09:00 PM by Amit Satpute

Database mirroring is done to increase the availability of data.

However, if the mirroring has to be disabled,

1. The ENDPOINT for the database has to be deleted.
2. Then execute ALTER DATABASE SET PARTNER OFF.
3. The ::= in ALTER DATABASE statement controls mirroring for a database.
4. Values specified with the database mirroring options apply to both copies of the database and to the database mirroring session as a whole and just a single is allowed per ALTER DATABASE statement

Next>>

Also read

What is the usage of the WITNESS instance in SQL Server 2005 Database Mirroring?

The WITNESS server is used to enable the mirror server to recognize the necessity of failover..........

SQL Server Transactions Architecture

What operations do SQL Server transaction logs support?
Explain the purpose of check points in a transaction log.
What is write-ahead transaction log?.............

Explain Full-Text Query in SQL Server.

Answer - SQL Server supports searches on character string columns using Full-Text Query......

Explain the phases a transaction has to undergo.

Answer - The several phases a transaction has to go through are listed here. Database.....

What is XPath?

Answer - XPath is a language defined by the W3C, used to select nodes from XML documents. ....