no you cannot, like a computername the virtual network name must be unique in the Windows domain

if using BP locked pages then you should configure both min and max memory for each instance

It's your lucky day!! Check the 2 links below for...

Sam -480699 (8/9/2010)

---

Hi,

Apologies if this has been asked before I did try looking around for a similar thread.

At the present moment my company has propsed that we need to...

Hi Ashwin

what you can do on XP is to set up a virtual SQL Server 2008 cluster. For this you will need the following

multi core processor

3 GB RAM

Windows 2003 Server...

let me re phrase that.

New in SQL Server 2005!

i'm assuming you're database mail, have you checked connectivity to the mail server?

Hi

copy_only is a new feature, it is basically a backup that does not interfere with the current backup chain. As Gail said, BOL does document this feature

tnk (8/8/2010)

---

However, one idea might be to drop the passive node out of the 2003 cluster, upgrade to Windows Server 2008, set up the 2008 Cluster with a different cluster...

in my opinion and experience, management who are lacking the key understandings are the real issue. They dont necessarily need to be a DBA themselves but they should have a...

wow this is really going off topic now, the OP only asked about cluster resources failing over from node to node 😀

Mike Hinds (8/6/2010)

---

Thanks for...

then you do not have your dependencies set correctly!

see my attached screenshot for details

Even with locked pages the OS can still ask ever so nicely for SQL to free some memory it just can't force it to as the buffer pool pages are...

With locked pages in memory sql server will never release below the min memory setting. It is important to set both the min and max memory when using locked pages.