ALL the cluster resources move?  and does the DBCluster2 instance start?  You should be able to see it in the Services applet. 

You got it.  The most common source of confusion in clustering is that people tend to speak of Servers and Instances as the same thing.  Even in a non clustered...

ServerA isn't unaware...Instance1 is.  That's why it's important to maintain consistency in terminology.  Instance1 will not see the drive that Instance2 uses, it can't or else the two instances would...

Profiler will give you the most complete and accurate data.  However, running Profiler can have a rather large impact on performance.

Define capacity planning.  Do you mean space or performance or both?

More details would be helpful.  However, the first thing to keep in mind is that when you run a DTS package (regardless of where the package is stored) it executes...

First off lets get terminology consistent.  You have ServerA and ServerB (physical servers) in a cluster, then you have two virtual servers (instances of SQL Server) that are independent of...

SQL Server needs to have the disk resouce defined as a dependency in Cluster Admin before it can use it.

Phill, 

If the maintenance plans fit your needs, using them doesn't necessarily mean that you are in full "wizard" mode.  Yes there are some things that the maint plans won't...

I can't speak for ramses2nd but I think it's kind of funny that so many people seem to spend so much time reinventing the wheel unnecessarily.  I have interviewed several...

Funny thing that Rudy should mention backups, because it is really only in the backup history that you can track changes to the size of your databases, that is unless...

CREATE PROC dupQuote (@oldQuoteID int

 , @NewQuoteID int)

AS

INSERT INTO test (QuoteID, Sector, Country)

SELECT @NewQuoteID, Sector, Country

FROM test

WHERE QuoteID = @OldQuoteID

About the only reason I've ever had to not use the maintenance plans is if you want to use differential backups. 

I suppose that if the current method provides a...

No, SQL Server doesn't delete rows for any reason.  Whenever I want to set up an audit trail like you mentioned, I use triggers rather than relying on the application...

If you are simply wanting to move the files to a new "drive" but have it on the same instance of SQL Server it will certainly require some downtime regardless...