This is not the most recommended configuration in consideration that we have DNS that can handle this.

Should one of the IPs timeout for some odd reason we could have unforeseen...

Please attach cluster verification report.

are there any antiviruses installed and running?

is the Ip addresses reserved and static or dynamic?

make sure that the IP addresses are static configured and reserved for the SQL cluster.

please attach...

Upgrading from SQL 2008 R2 enterprise to SQL 2014 enterprise using in-place upgrade for a clustered environemt. Are there any issues with jumping straight to 2014?

hi,

I once had similar issue and i used a combination of database level triggers and Server level triggers.

Foe Database level it was for checking who and when data was deleted...

Hi,

You may also try detaching the databases and copying the mdf & ldf databases to the new environment and re-attaching them.

That usually works, but obviusly you will require downtime for...

Hi,

do you mean if his key is formed like a composite key?

Anyone with an update with regard to this?

Hi,

I have a slightly different scenario, I have a SQL 2005 SP4 cluster instance that i need to upgrade to SQL 2008 R2. How do i go about doing this....

Ok Thanks a million, i shall let you know of the outcome.

Hi,

Could index fragmentation have also have an impact on this problem?

If there are index fragmentation perc of above 40% with majority sitting at 95-97%.

Can index rebuild help with the trn...

Hi,

Do you mean i should restrict log growth to 1MB for instance?

Cause currently the database is set to unrestriced growth of 5MB.

Yes what DLL?

Can you also detach\attach mdf and ldf from 2008 to 2012 instead?

So i have to first upgrade the instance to 2012, i thought there's a new better way.

Thanks thou.

ok it works but no results