Hi Kevin,

The link server will have to be created on a production and i am afraid if that the will break things up.

But you are right,...

thank you guys for the reply and so sorry for reverting so late!

Hi Steve,

Thanks for your help!

I have setup monitoring via task scheduler + powershell (get-service) on the SQLserver + SQLAgent service.

On point 2) So far , I have only thought...

Perry Whittle (11/10/2016)

---

szejiekoh (11/9/2016)

---

Can you elaborate further if there are 2 DNS entries per AG listener, what if the DNS resolution (round-robin) resolves to the IP/subnet in the secondary replica...

Perry Whittle (11/10/2016)

---

szejiekoh (11/9/2016)

---

Perry Whittle (11/8/2016)

---

why on earth do you want the...

goher2000 (11/9/2016)

---

q1)

all ports must be open between three nodes multi subnet or not. check out the ports

Windows Server Clustering –

TCP/UDPPortDescription

TCP/UDP53User & Computer Authentication [DNS]

TCP/UDP88User & Computer Authentication [Kerberos]

UDP123Windows Time [NTP]

TCP135Cluster...

Hi...

GilaMonster (11/7/2016)

---

szejiekoh (11/7/2016)

---

q2) As part of the release process, Do we also have to add the following line in the script ->

"EXEC msdb.dbo.sp_update_job @job_name='Your job name',@enabled = 0 "...

Hi Gila, Perry,

Thanks for your wonderful advice!

q1) By scripting the job out, do you mean in "SMSS -> SQL Agent -> Jobs -> Jobname -> right click , Script...

Perry Whittle (11/4/2016)

---

szejiekoh (10/31/2016)

---

What would be the best practice to "copy/replicate" these jobs over ?

-- doing backup of msdb and frequent restore to the mirrored/replica instance ?

No!

do not do this,...

Hi Kevin,

Sorry for the late reply.

Thank you so much for your confirmation.

Regards,

Noob

Jeff Moden (10/5/2016)

---

I'm curious. You would have had to try this out anyway....

Hi Kevin,

Thanks for your reply. I understand where you are coming from, but the setup is done via an external vendor and I need to get my facts right before...