The failover tab details whether fail back of the resource occurs to a preferred node. It also specifies that if multiple failures occur within a given time period the application...

This link details the policies tab

If you do join a clustered instance to an AO group you will not be able to use automatic failover.

javirsantos (11/15/2013)

---

When I install the SQL SERVER 2008R2 SP2 CU1 offline disks fails and leaves the failed instances (clustered).

I roll online and instances discontinuous work well.

When you uninstall CU1 fails...

You should still be able to move it using the commands above, works just fine for me

Can you post the output please

can you detail the steps you used to deploy the log shipping plan and whether using GUI or scripted

muthyala_51 (11/14/2013)

---

I tried it on a test server using the command prompt command. I can move the cluster group but i still see the quorum drive on the passive node...

shindle 17293 (11/14/2013)

---

I have a db that has 3 data files. The first data file is on one drive and the remaining two on another. All three were set to...

why rename the job?

For each instance you want to monitor an LSAlert_instancename job is created.

A single instance can be used to monitor multiple log shipping plans

RTaylor2208 (11/13/2013)

---

If I am interpreting your post correctly are you saying that you have two physical servers participating in a windows cluster.

On each node you've a SQL server installation you...

The setup account requires administrator permission to carry out the install. The service account should be a basic user account.

Running multiple instances on sql on the same node is not uncommon or bad, in fact its a good way to get the most from your hardware as long as...

just query this from each instance and compare the values, no need for reams and reams of code

SELECT SERVERPROPERTY('Computernamephysicalnetbios')