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...

where did you get the DVD image from?

to re use the hardware, i would uninstall one node leaving the cluster effectively a single node cluster. I would then temporarily virtualise this system to keep it running side...

From memory the installer wont let you select a shared drive, if you do it warns that the drive is a shared drive and forces you to make another selection

Redgate SQLBackup Pro also...

you're welcome!

It probably wouldnt take too much work to convert this into...