ah, that makes sense, out of 160 rows one of them =2 about half way down.

Thanks for taking the time.

D.

Andeavour,

Thats pretty much where I am to be honest, but as the DB's are not hammered night and day, I think things will work out fine.

Regards,

D.

Thank you for your reply's, that basically clears it up for me.

Regards,

D.

Perry,

We are also thinking of placing Analysis Services on the cluster and I read on old article that in regards to SQL server 2005, it was best to keep AS...

Hello,

There was one more thing I wanted to ask, as I understand it, in a Windows 2003 cluster it was good practice to put the heartbeat network as 2 NICs...

Hi Gail,

Of course you were spot on, I did not notice a truncate-only job running under the agent between Fridays full and Monday's T-log backup.

Regards,

D.

ok, thats good to know, as someone told me that I would need to set aside 15GB for a quorum, which seemed excessive to me. I take it 2GB would...

Thanks again for getting back, I have one other question. Does the number SQL instances have an effect on the size of the quorum? And if so, by how much?

Apologies...

Thank you, that makes perfect sense. Does this also mean that the file share, in some sense, can work as a backup copy?

Regards,

D.

I am using WINDOWS 2008 R2 Enterprise.

Regards,

D.

Release 2.

D.

Hello, thanks for getting back.

I'll be using SQL 2008 64bit Enterprise Edition.

Regards,

D.

That's perfect, thank you.

Regards,

D.

Hello,

OK, so the instances would failover and continue to be available on the one remaining node, so the hardware on each node would need to be powerful enough to take...

Hello,

Thanks for getting back. So if I am following you correctly, on Node 'A' I can have instances 1,2 and 3 and on Node 'B' I would have instances 4,5...