One last thing, TempDB has been setup with a local drive on each node of this cluster, so the TempDB mdf and ldf, do not reside on the M:\ and...

I feel that the order of operation here should be:

1. Create backups of all user databases and systems databases.

2. Detach all User databases

3. Copy all files in...

Perry,

This a 2 node active/passive cluster and they are both at the same site.

Thank You

Thanks Perry, I am going to need to Google this quorum stuff that you mentioned!!

Thanks Again!!

Thank You Maddave!!!

Does this type process work for the quorom? We need to reclaim alot of that space to be used else where.

Thanks Again.

One more bit of information...

Using this link:

http://social.msdn.microsoft.com/forums/sqlserver/en-US/04bce059-5a37-41bd-a813-a3f24fd359c6/passing-arguments-to-execute-process-task-in-ssis-2005

The Standard Output variable is telling me:

User::StdOutput{\r\rRecipients' public key(s) will be used to encrypt.\r\rCannot find the public key matching userid 'user'\rThis user...

Three more bits of information...

1. I have found that exit code 21 means "The device is not ready"

2. This is failing while running the package via BIDS.

3. ...

Thanks for the replies!!! I will get with our Sys Admin/VMWare guy about those quesions.

So it does seem to be easy it sounds?

Thanks Jack for the response.

I have another question, I just started at this job and I am seeing tables that do not have a PK or a Clustered...

To be sure I did not gather statistics for the local VM (Windows 7), I re-opened a new Data Collector set and before changing the <Local Computer> to my SQL...

Michael,

The perfmon showed all 8 processors, 0-7 and I selected each one of them individually to add them to the perfmon. Also, I will be researching Max Memory settings...

Another thing that is weird...I wanted to get statistics for the drives that host my data and log files (two separate drives) and they both have no data in them...

I actually got it to work...

I took just the UPDATE statement you provided, took out the variables, input what I needed, and I was able to update my column as...

Thanks for the replies!!!!

The solution that has been provided doesnt actually update the field. Copying that out into SSMS and running it looking at the resulting XML column, there...

Evil,

I am indeed on SQL Server 2005.

Thanks for the help!!!