February 13, 2014 at 10:10 am
I have a number of SQL servers which are using a four part fully-qualified TCP address for the Server network address in database mirorring. i.e. TCP://ServerName.Location.DomainName.com however I am going to have to drop the DNS entries for the four part name and use the three part name instead but cannot find a way of changing this server network address.
I can find it with the following query "select mirroring_partner_name from sys.database_mirroring" but that is a system view which isn't updatable. Have I any options other than removing mirroring and setting it up again?
February 13, 2014 at 2:45 pm
Use the GUI to alter the endpoint address, or use the ALTER ENDPOINT command.
February 14, 2014 at 3:42 am
How do you change the address through the GUI without having to remove mirroring for the databases, by using the Configure Security route does not give that option.
Also with the ALTER ENDPOINT command what syntax do you use to change the address for TCP protocol?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply