I have created a 5 (hopefully soon to be 6 if I reclaim my other node from networking) node cluster. If we are talking Enterprise SQL then the limit...

Correct. The thread-starter did not mention versions and since they seemed to know what copy - only backups were I assumed they were on SQL 2008.

db

You can definitely create a job within SSMS to run a piece of SQL code which could be a Copy Only Backup.

And I really have no idea why...

You need to add a T-SQL step to your maint plan and insert the code for the copy only backup there.

you cannot do it with the backup task in the...

We are considering it here as well. I have watched a presentation put on for us by the Microsoft Primary Tech for DPM for the eduction sector and it...

There are 2 ways I know of and use on a daily basis to move a SQL resource between nodes.

1.) Right click on the resource in the GUI and...

Err. your SE part of the question escaped me again. I need to stop replying this early in the morning. In my opinion based on the wording...

Sorry i misunderstood. The way you said it seemed odd.

You can absolutely do what you want to do. Say you had 3 nodes (A,B,C) and 2 clustered SQL...

In SQL 2008 that is not accurate. You CAN do the one install process where you "prep" each node and then run the final process to enable them all.

...

Sorry , I also did not answer the other part of your question. You are limited to 2 nodes with SQL 2008 Standard. You can have 16 nodes...

---Markus,

There really is no difference between cluster types they are all really the same animal. You could have 2 nodes with only one instance so in theory its active/passive...

Silverfox's post did contain the answer but I will explain somewhat further. If you want to have MSDTC installed in your cluster then YES you must install the Application...

When you go to install SQL on the cluster you will have to type in a name for the clustered SQL resource and it cannot be something already used. ...

---jocampo

Have you installed the SQL instance on both nodes? You must install each instance you intend to run on every node. If you look on the drive you...

I'm fairly certain you cannot do exactly what you are asking. Different clusters cannot share a machine. Either the machine belongs to one cluster or the other.

But...Why not...