Just to follow up, I ran SP1 on each node and it upgraded just fine. Not sure what the slipstream issue was but at least i have my cluster...

Thanks to all on this Thread, I'm really glad it was here.

Got a couple wierd things though

I went to

http://blogs.msdn.com/b/petersad/archive/2009/03/02/sql-server-2008-basic-slipstream-steps.aspx

but got the error

The following error occurred:

The setting 'PCUSOURCE' specified is not...

Just wanted to toss out the link to the technet article that references the Perf_warehouse example, in case you need it.

http://technet.microsoft.com/en-us/library/cc966545.aspx

TempDB can hold a variety of information.

Work Tables for Groupby, order by, and union queries

Work Tables for Cusor and spool operations

Work Tables for creating/rebuilding indexes that specify the "sort_in_tempdb" option

Work...

I'm not an SMS, SCCM, MOM, or SCOM expert, but I have always backed up the databases. And when one of the drives failed it was invaluable when it...

DUDE chill out.

There are other consideration that just what you want to do. I completely agree with ejecting the Node, rebuilding it, and re-adding it.

I was flat...

I can't speak to upgrading standard to enterprise.

However there are cluster limitations on the number of nodes you can run on Standard vs. Enterprise.

Standard can have only 2 nodes regardless...

look at the sql error log, how long does it take everything to come back online. there should be an entry that says

"SQL Server is now ready for...

I understand your concerns, I'm hoping that SP2 will re-register the components in the registry to match the way the cluster is configured.

but I don't think we will know until...

Here are some things to check.

1. open up perfmon, in the main window add the disk queue lenght counters for each individual drive. If one drive (the drive your...

While this could work as a temp fix, the SP2 fix we were talking about would be better.

the main danger in this is that when you look at the registry,...

Is that using powershell? I've not had time to play around with it at all, but I'm very curious to. I suspect that everything I've used t-sql for...

Glad to hear it!

The team I used to work for had this same issue a couple months after I had left, and I had a drive fall out on a...

I believe that is because SQL stores the physical location for backups, and it does not store the physical location of other file types.

I don't know the full architecture behind...

The restore is occuring on the same physical box?