Thanks for a great article on something I knew was there but thankfully haven't had to implement yet.

I have not ran the uninstall. I postponed the removal and have to get another maintenance window for the work, but will post the results once complete.

Hi Perry,

Thanks for the reply.

Do the services need to start on the active node? I am removing this instance from the cluster (uninstall on both nodes) and...

If you really need to add the Central Management Server to a group that it maintains there is a work around to do that.

You can begin a New...

I gave a quick call to Microsoft to check on the connect "Bug" that I found and they said it was not a bug. I had to cycle the...

GilaMonster (3/14/2012)

---

Yeah, the LOB data cannot be moved if it's stored out of row (if you have LOB_DATA allocation units). There is no way to relocate that, the only option...

I've been doing this well for the past month using the DROP_EXISTING = ON, but had a follow up question. Are there any special considerations for a table with...

OK, thanks for the replies. I'll work with the DROP EXISTING and since I'm using Enterprise look at the ONLINE = ON as well.

My server guy hadn't used ICACLS before so I can't help there, but he did mention the same that I've said about propagating permissions down to child objects under the...

hayden_jones (2/7/2012)

---

1. The domain id that runs the SQL service is in the Administrators group on the Primary node, but not on the Secondary node. I don't know...

I've never had to use icalcs (looks like a tool for applying permissions though - http://ss64.com/nt/icacls.html). I changed the service account for several instances last summer and our server...

That is strange. I noticed that you have your mastlog.ldf on a different drive from your master.mdf. I kept both of those (as well as the resource DB...

hayden_jones (1/23/2012)

---

Yep. I think I have that all covered and tested. Thanks for the support. What I'm still not clear on is the starting of the instance...

Good question and I never thought of using Resource Governor for backups, but I agree the answers should be A & D since the explanation deals with CPU in resource...

In my recent hardware/OS/SQL upgrade I could not find any easy way to do this at all so, I had to recreate them on the new instance. I only...