Windows 2008 now offers the ability to create multiple clustered DTC resources, you could have one for each instance or just use the one

keep the locked pages but you will need to review your MAX Memory settings!

more importantly, SQL Server does not care whether the quorum is an MNS or a disk!

rdecker (8/4/2010)

---

Hi Perry,

If we used a witness then it would be a 2 node cluster anymore. Unless I'm mistaken a majority node set with a witness would require at...

WayneS (8/4/2010)

---

Perry Whittle (8/4/2010)

---

Hmm yes, the only issue with that diagram is the Quorum assignment! I would use a majority node set with a witness and put the Quorum mirrored...

you're wlecome.

you would need to either move the group via cluster administrator or pull the public network connection on the active node for the service to fail over!

Hmm yes, the only issue with that diagram is the Quorum assignment! I would use a majority node...

blue_inelush (8/3/2010)

---

an application that will do stop-start for the sql server service. The only problem is that my Sql Server 2005 is installed and configured on a cluster environment and...

Hi

also try to post in the correct forum. Posting a topic from which i can see has nothing to do with high availability in the HA section is not a...

ALZDBA (7/31/2010)

---

What else would be the purpose of a mirrored db, if you still lose time when you cannot afford it (i.e. at failover time) ?

Meaning if you would...

the failover partner connection string parameter is only required if confuring automatic failover. You need to be using either the SQL native client or ADO.NET

Hi

shrinking or growing a database will affect the database file size and ultimately the location of portions of the file on disk (they won't always be contiguous).

The OS file...

Yes!!

Lowell pretty much has the take here, dynamic ports on sql server instances will give the issues you are seeing only upon instance restart though!

Depending on how you connect you...

Ashaaban

what edition is your SQL Server 2008?

i.e. standard, enterprise?

If you're using Standard edition the lock pages in memory option is ignored unless you have SQL Server patched to SP1...