Bringing the SQL Server agent online first will automatically bring SQL Server up due to the dependencies between these resources 😉

That's an excellent link. IMHO anybody who hooks a SQL Server system up to a storage system without completing IO tests needs their brain looked at 😀

Thank you, I could possibly add the witness setup to the VMWare based doc but I don't have or use Hyper-V.

Its very easy, just configure the cluster as usual using...

neither, in my opinion RAID group 2 is the weak point. I would opt for multiple smaller arrays!

Robert

remember as you are implementing a cluster you will inherently have more than 2 machines on the network (a cluster is dependant upon DNS and AD).

You cluster the 2...

OK, taking RAID group2 from your diagram link above you have 1 RAID 10 group carved up to service

TEMPDB data

user DB data

Backup data

Sharing storage amongst 3 LUNs will likely not...

sivaprasad (7/28/2010)

---

Environment:

Single Node cluster

SQL Server 2005 with default instance

O.S: Windows 2003 with KB937444, Microsoft .NET Framework 3.5 Service Pack 1 & Windows Installer 4.5

The upgrade of SQL 2005 cluster...

is this...

for an OLTP system shared storage is a bad idea!

Windows 2008 now offers the ability to create multiple clustered DTC resources, you could have one for each instance or just use the one

keep the locked pages but you will need to review your MAX Memory settings!

more importantly, SQL Server does not care whether the quorum is an MNS or a disk!

rdecker (8/4/2010)

---

Hi Perry,

If we used a witness then it would be a 2 node cluster anymore. Unless I'm mistaken a majority node set with a witness would require at...

WayneS (8/4/2010)

---

Perry Whittle (8/4/2010)

---

Hmm yes, the only issue with that diagram is the Quorum assignment! I would use a majority node set with a witness and put the Quorum mirrored...

you're wlecome.

you would need to either move the group via cluster administrator or pull the public network connection on the active node for the service to fail over!