Failover is not just associated to the heartbeat. The Public connection is also taken into account. If the public NIC is not responding communications with Live applications will be unavailable...

if the agents don't exist they must have been removed. I personally would attempt to clean them up using the stored procedure.

SQL Server creates a clustered index by default on the PK, but its not necessarily the best it depends on the design of your tables. Each scenario is different

Jeffrey Williams-493691 (8/31/2011)

---

To create a multi-instance cluster, you need to create separate resources for the new instance. That is, you will need an IP address/name, separate disk drives and...

have you tried clearing them anyway

If you want to concoct your own scripted LS process that would be viable, either way the...

That wont cleanup the LS agent histories. The following stored procedure is used to cleanup agent history based on the...

what steps are you taking to prune history?

BigSam (8/31/2011)

---

I'm upgrading SQL2k8 to SQL2k8 R2 in a 2-node cluster. The servers are running W2k8 Ent.

I followed the information in Microsft's guide

http://msdn.microsoft.com/en-us/library/ms191295.aspx

I've upgraded the passive node to R2, but...

More importantly the OP hasn't provided details of the storage on the stand alone server which i'm asuming is using local disks unless told otherwise

Could you execute the following and return the results for disk6

wmic partition get BlockSize, StartingOffset, Name, Index, type, primarypartition

robster (8/31/2011)

---

I have a dynamic disk (4.5TB) in size which is SAN...

Do you have the diskpart commands to create the new partitions

Sql server 2000 standard does not support log shipping!

What edition is your SQL 2000 instance?

Ok but if you log ship between 2000 and 2008 the database can only be in restoring mode!!!