That's pretty much what would happen when you installed SP1 a file wouldn't get copied to one of the nodes.

Wes

You are sure the cluster is functional without installing sql enterprise on it first yes? The only thing close to this is the problem some of us had installing SP1...

Don't forget you cannot put a database in single user mode while people are attached to it.

Wes

Well the best to hope for is to run an active/active cluster and then horizontally partition the data accross the two instances. I have tested this out several times the...

I have used the tools in the sql res kit and ERwin to do estimations on database migrations. You may want to give them a look.

Wes

We found that rolling foward with doubletake was fine but pushing back onto the original equipment was not as easy and could have resulted in excess downtime.

Wes

If you go with an external scsi solution you will want a array that has one bus so both machines can see all of the drives and share them. You...

Well, I would go with two servers attached to external scsi array. Its cheaper than SAN and faster than any real NAS you are gonna buy. You will need to...

Worse come to worse you can always just restore the mdf files and re-attach them to a clean install and let the server rebuild the log files.

I will try to come up with some solutions for you this week.

Wes

Are you making db struct changes or just changed to stored procs? If it is the latter I would test on B then just push the new stored procs to...

double poster! :). I agree with everything but one point... I still love the 0+1 setup for raid. I currently run my temp db off of a 0+1 stripe since...

you have to have sql ent for active/active or active/passive. The node will not fail over properly if you don't.

here is a function I include in all my asp pages that have text fields that can can accept input.

function SQLparse(s)

'*********************************************

'* This just does a charater replacement on my

'* insert...

I have never got a link server to work with anything but the 7.3 client. here is a little tech article

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q277002

Wes