I don't understand what domainlet is. When you do the cluster install I would make sure both machines are apart of the domain. Secondly, Make sure all the services start...

I have a gut feeling that one node didn't get upgraded. Look at this technet article and reapply the SP1

http://support.microsoft.com/support/kb/articles/Q306/0/34.ASP

Wes

I was also thinking you could do a horizontal view across both servers.

in an A/A setup you are running two copies of sql. they are basicly seprate and do not talk to each other. If one node fails the other node gets...

You can't remove the load balancing if you want your app to pull from ether server. In an active/active mode you basicly have two sql servers with two diffrent names...

I have he MSDTC services up I'll check it out again.

Thanks!

Check your HBA's and your nic setup. I can't imagine a SAN setup taking that long. Did IBM set the cluster up or one of your local admins?

no that isn't normal at all. My cluster fails over in about 15 seconds. can you describe your hardware/software setup to us?

I get the fixed drives data and dump it into a temp table I dont' select just one drive. I'll see if I can replicate your error.

Wes

out of any db on the server I always give tempdb as much IO and disk space as possible. You can bring a server down quickly if your tempdb is...

I love the sql 2000 database design book from Wrox press.

Wes

We put all web servers in the DMZ and only allow them to talk back to the sql servers. I setup users that only have read or write access to...

you my also run a dbcc with dataloss and it should bring the tables back to a useable state. I think 🙂

we rolled it into production today all went exactly as expected the Q article is correct.

Wow, Have you looked at restoring the master, msdb, and model from tape? In an active/passive both nodes share the same physical datafiles and in an active/active the same is...