18. You have two instances on a server that need to be able to send messages
between the instances. Your corporate IT policies say that SQL Service Broker
Endpoints must be created on TCP port 5600. You create and bring online the
first Endpoint, but you cannot get the second Endpoint to come online. What
should you do to correct the issue?
A. Add a second IP to the server. Configure the first instance to use the first
IP for the Endpoint, and the second instance to use the new IP for the
Endpoint. Start the Endpoint on the second instance.
B. Change the port number of the second instance to a different port number
using the ALTER QUEUE command and bring the Endpoint online.
C. Restart the SQL Server instance that has the Endpoint that will not
come online.
D. Use the ALTER ENDPOINT command with the FORCE_ONLINE
switch to force the Endpoint to come online.
The correct answer is A. Because your IT policy states that the Service Broker
Endpoint must be created on TCP port 5600, a second IP address must be
added to the server so that each Endpoint can have its own IP to listen on.
Restarting the instance will not help bring the Endpoint online as the port
number is locked by the other instance. There is no FORCE_ONLINE switch
for the ALTER ENDPOINT command.
Bạn đang xem 18. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P162 PPTX