Ok a bit more to add.

My opinion is that no extra dependencies needs to be added to MSDTC as there is an option for:

If restart is unsuccessful, fail over all...

Ok I had a go at this and just did a move of the MSDTC into the SQL group and the dependencies went with it.

I am still after answers to...

For those interested what I eventually did with this was to follow this article:

http://support.microsoft.com/kb/953505

Although this article seems to set out how to get the instance into a prepared state so...

Ok seems you can't put the system databases on a drive thats not part of the cluster. In that case I have just put them on the SAN disk...

Ok - I have read that it may be possible to manually rebuild the cluster resource groups but I have no idea how to do that. Would that allow...

Ok great thankyou very much 🙂

Sorry can I just clarify this.

I will be needing 2 resource groups. One containing a SQL and MSDTC install, and one containing SQL, SSAS and MSDTC.

I will therefore need...

Top explanation again Gail thankyou 🙂

Hi there and thanks for the reply.

Using your code I get 8KB extra which equates to one extra page when adding up the pages from all levels except the leaf...

Hi sorry for the late reply I have been at SQLBits 7. The Quorum would have been the default at the time, the problem is I didn't do the...

hmm ok I am looking at this more as I am unfamiliar with Failover Cluster Manager in Windows 2008.

It seems we have 3 resource groups

MSDTC

SQL Instance 1

SQL Instance 2

I...

Ordered thanks.

Ok so I will be fine leaving master\model\msdb on the local drive rather than the SAN, and I will move tempdb to its own LUN?

Obviously the User databases will use...

Hi Karl - That was a useful explanation thank you.

We are on 2005 RTM (I know!) - I will have to schedule some downtime to run the repair correctly.

As for root cause analysis, we don't know when it happened...