I'm in this specific position right now.  I've been a bit restless, and on-call support is wearing me down.  The work is pleasant enough, but not stimulating, and initiatives for...

Psst...we can still see your table names, not sure if you're okay with that.  It's not 100% opaque..

Oops, I mean KEEP the cluster, but evict the nodes at the end after I've copied over to the new instances. Will definitely take a look at that. Thanks!

gotcha...so, to use existing hardware, I'd need to break the cluster. Would the best recommendation be to create two new instances, one on each server, migrate from each active...

So it's been a while, since the last comment, and I've changed companies. Revisited this code because we have the PERFECT scenario where it is useful, as we spin...

Thanks Gail and Jack for your input. As I'm finally getting exposure to live 2014, I need to unlearn some things in 2008 (non-R2). I would use Ola's...

Thanks everyone for the tips. Jonathan's book for the team, but maybe Kalen's book for myself. 😀

Sometimes, I want a script without too many bells and whistles. That was mainly it.

No, it's off...it seems that 1433 indeed was not listening. However, we had to let the network admins open up our new port....

Anyone? 🙁

Attached are three lines that might be important from the Errorlog. Not sure if the \pipe connections matter.