Advantages of an SQL 2005 cluster from transaction point of view

Giganews Newsgroups
Subject: Advantages of an SQL 2005 cluster from transaction point of view
Posted by:  Sabi (Sa…@discussions.microsoft.com)
Date: Wed, 16 Jul 2008

Hi Guys,
We are considering whether an SQL cluster (MSCS) may have any advantages
from transaction handling point of view. I mean mscs is a solution to correct
only hardware failures but it does not have any advantages on transactions
level. We are making a comparison between SQL log shipping and clustered sql
servers, this is why it is an important question. Do you have pros cons on
any side but only from transaction point of view? As i understand
transacation loss could be occur on clusters as well if a node crashes so sql
log shipping could be more secure in this case. Any advantage on cluster side?
Thank you for your help!
Sabi

Replies