_taz_ (7/15/2010)

---

Robert Cary (7/15/2010)

---

Your connection string would look something like this:

Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;

The application will connect to whichever one is available, if the primary fails, the application connections...

That's fine Std supports a 2 node cluster

james.christou (7/15/2010)

---

What we want is instance A and instance B...

also 2 node clusters are only available in Std and Ent editions!

which edition of SQL Server 2008 are you using?

Litespeed and SQLBackup are both comparable products nowadays. I personnally found SQLBackup better on compression than Litespeed on my test databases

Hi Cindy

if we're talking a straight VM with standard VHD's then in my experience VMWare HA is generally quicker and less fuss than MSCS!

During my first encounters with ESX...

there's no mention of backup files where do you intend to put these?

for more on creating virtual clustered environments check my article here

Hi Cindy

thank you for citing my article, its good to know people do read them! Let's start at the beginning here.

The first question, disregarding virtualisation at this time, is do...

on a Windows 2008 cluster, you do not have to take the SQL Server service resource offline when removing a disk dependency!

?

Mani-584606 (7/6/2010)

---

From Add/remove programs, I have selected remove and in the SQL Server setup wizard, I have selected the...

ok and what did you...

are you referring...

Ratheesh

have you removed the Builtin\Admins from the SQL Server instance?

If not login to the server as the local admin account and gain accessto the SQL Server instance.