Which actions could you take to accomplish this?

You are the database administrator of your company. You create a two-node SQL Server 2008 failover clusterinstance and configure database mirroring for a database named
Products. The database mirroring sessions arealso configured to support automatic failover. You are relocating the two SQL servers. You want to disableautomatic failover.
Which actions could you take to accomplish this? (Choose two. Each correct answer presents a completesolution.)

You are the database administrator of your company. You create a two-node SQL Server 2008 failover clusterinstance and configure database mirroring for a database named
Products. The database mirroring sessions arealso configured to support automatic failover. You are relocating the two SQL servers. You want to disableautomatic failover.
Which actions could you take to accomplish this? (Choose two. Each correct answer presents a completesolution.)

A.
Connect to either of the partner servers, and run the ALTER DATABASE Products SET WITNESS OFF statement.

B.
Connect to either of the partner servers, and run the ALTER DATABASE Products SET WITNESS ON statement.

C.
Connect to the principal server, and run the ALTER DATABASE Products SET PARTNER SAFETY OFF statement.

D.
Connect to the mirror server, and run the ALTER DATABASE Products SET PARTNER SAFETY OFF statement.

Explanation:
You could connect to either of the partner servers and run the ALTER DATABASE Products SET WITNESSOFF statement or connect to the principal server and run the ALTER DATABASE Products SET PARTNERSAFETY OFF statement.
When you use database mirroring with failover clusters, the database mirroringsessions can be configured for automatic failover.
Automatic failover ensures that if one node in the cluster fails,the other node takes over immediately.
To support automatic failover, the database mirroring session must berunning with a witness in synchronous or high-safety mode.
To disable automatic failover, you can either changethe operating mode of the database mirroring session to asynchronous or turn off the witness. To change theoperating mode of the database mirroring session to asynchronous, you should connect to the principal serverand run the ALTER DATABASE Products SET PARTNER SAFETY OFF statement.
To turn off the witness, youshould connect to any of the two partner servers and run the ALTER DATABASE Products SET WITNESS OFF statement. You should not connect to any of the two partner servers and run the ALTER DATABASE Products SETWITNESS ON statement.
To disable automatic failover, you should turn off the witness. To do this, the SETWITNESS OFF parameter is used. You should not connect to the mirror server and run the ALTER DATABASE Products SET PARTNER SAFETYOFF statement. To disable automatic failover, this statement must be run on the principal server, not on the mirrorserver.

Objective:
Implementing High Availability

Sub-Objective:
Implement a SQL Server clustered instance.

References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > High Availability > DatabaseMirroring > Database Mirroring Overview > Database Mirroring Sessions > Role Switching During a DatabaseMirroring Session > Automatic Failover



Leave a Reply 0

Your email address will not be published. Required fields are marked *