Evening Perry,

can I confirm the steps:

1) Windows Cluster

2) SQL Server Cluster

3) Then add MSDTC to the SQL SErver application via right click application, add resource,more resources - 2 add distribute...

have you looked here http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/503da08c-a4f1-44b2-b997-9c7bf7e0652e/

Hi Duran,

microsoft white paper SQLServer Failover Cluster:

On Windows Server 2008, you can install multiple instances of MSDTC on a single failover cluster. The first instance of MSDTC that is installed...

Hi Duran,

I have done some search (re a MS DTC error after unexpected shutdown), please have a look at this

http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/c751c901-6fbf-48b1-a079-6b91e738f67b

As for your question:

Well, the idea is that...

you need to create another shared disk, if you have got only 3 disks, 1 will be data,2nd - logs, 3rd -quorum and you will need to add one...

I would take the sql server application offline and then power down passive node, active node.

Perry, your opinion?

I recommend to use MS script using sys.dm_db_index_physical_stats at http://msdn.microsoft.com/en-us/library/ms188917.aspx

Version 2008 R2, but versions up to 2005 are available.

If you install Microsoft Distributed Transaction Coordinator (MS DTC) in your SQL Server group and you have other resources that are dependent on MS DTC, MS DTC will not be...

do you configure windows cluster too? or are you interested in sql server cluster only?

if second option, speak to your network & storaga guys and ask them to configure storage...

not really,

but we will be running SSIS on the SQL Server

I see, you are using an array solely for the SQL server or not?

in my case I may have a shared array and that's why I am getting all...

Do you mean that you have went for one array partittioned into 3 LUNS or 3 arrays partitioned into 3 LUNS?

hi, yes I agree that it is a good way of doing it, but if you have the LUNS arranged over one array of disks, then isn't it defying the...

Sorry for highjacking the thread.

Can I use a local machine drive for the temp db? and get the data & log files on SAN?

Well, I cannot 🙁

Rebuild all indexes via alter <<index name>> on <<table name>> rebuild

then run exec sp_updatestats