Mirror - High Protection

Question

Hello, I have a database mirroring setup (High availability option) in a production system.

Can I use the syntax:

ALTER DATABASE mydb SET PARTNER = 'TCP://new_witness'

To change the current witness server (old_witness) to another server (new_witness)?

Do I need to do anything else? Would that affect mirroring?

Thanks

Answer 1

0

As discussed here, you only have one witness, so yes ALTERing the database properties should change the existing witness.

answered Nov 04 '10 at 02:55 AM

Kev Riley ♦♦
46.1k ● 39 ● 43 ● 69

(comments are locked)

Answer 2

0

To change the witness, you'll want to use SET WITNESS rather than SET PARTNER

answered Nov 04 '10 at 01:40 PM

KenJ
12.4k ● 2 ● 10

+1 good spot didn't even see that, just read what I wanted to read!!

Nov 04 '10 at 05:28 PM Kev Riley ♦♦

thanks for the correction, that was a typo.

Nov 05 '10 at 01:52 AM elias_chatzigeorgiou

(comments are locked)