Hello!

We are preparing to install SQL Server 2008 Active/Active Cluster on
Windows 2008. We are currently contemplating whether we need a dedicated
drive for msdtc resource, etc. I was wondering if somebody can recommend any
good articles/white papers with step by step instructions/best practices
starting from OS installation/configuration and covering SQL Server part as
well.

Any advice is greatly appreciated.

Thanks,
Igor

Hi Igor,

You have 2 choices.

1. Placing MS DTC in quoram drive. Since the quoram is heart of the cluster
it is better not to configure MSDTC in quoram.
2. Placing MS DTC in backup drive will be a ideal choice because the other
drives like data & log are critical for SQL Server in terms of availablity,
performance etc.,

Thanks & Regards
Balaji

"Igor Marchenko" <IgorMarchenko (AT) discussions (DOT) microsoft.com> wrote

See if this helps:
http://weblogs.sqlteam.com/geoffh/ar...-Clusters.aspx

I wrote it for SQL 2005, but the same reasons apply to SQL 2008.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Igor Marchenko" <IgorMarchenko (AT) discussions (DOT) microsoft.com> wrote

You may refer the article link :
http://www.sqlmag.com/articles/index...ticleid=102461 on it. It provides
detail.

You need to subscribe to the site.

Warm Regards,
Arindam.

Igor Marchenko wrote:

SQL Server magazine had a great article that describes the process of setting
up SQL Server 2008 cluster. It was in the September issue:
http://sqlmag.com/Article/ArticleID/...er_102461.html

/MRW


"Igor Marchenko" wrote:

Thanks everybody for your feedback! It is greatly appreciated.

See thah:
http://itprosecure.com/blogs/windows...rt-1-of-3.aspx



Igor Marchenko wrote:

Thanks everybody for your feedback! It is greatly appreciated.
12-nov-09

Thanks everybody for your feedback! It is greatly appreciated.

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Silverlight Toolkit: Autocomplete TextBox Stock Symbols and Chart
http://www.eggheadcafe.com/tutorials...lkit-auto.aspx