Hmmm, Roy, is Willemstad close to you? $650 in Feb from here. Is there a lower cost time to come out?

Definitely not a bother, though I...

I'd would be very curious if this worked when you failed back.

So, just to make it clear.

NodeA - Normally active node

NodeB - Normally passive node

- Jobs run on NodeA

- Failover...

I can't find it documented, but perhaps an allocation is counting as a split for some reason. I'll see if I can get a back channel response.

I have typically had jobs owned by sa, but not used sa for the Agent connection. That shouldn't be needed.

I don't know if the owner needs to be the same,...

Everything's kinda on that screen. I think you ought to try this yourself first and if it doesn't work, let us know what you've done.

I agree with Gail, I don't expect that you can do this. A backup is needed, and I'd caution you to note delete data if you don't have a backup.

Grant Fritchey (7/15/2010)

We've talked about it a few times, but there hasn't been a lot...

I'll chime in as well, Paul. People every day still use @@identity and forgo transaction log backups. If you've solved it, likely there are a few thousand people out there...

tx, fixed

Do you mean that you are inserting the PK value into each table and can't rewrite the inserts?

Honestly how long can it take, and if this is an update issue,...

Thanks for the update. I suspect it was a transient error where somehow the Agent didn't move over and properly connect from the passive node.

If you can schedule downtime, or...

This apply? http://blogs.msdn.com/b/karthick_pk/archive/2009/01/14/unable-to-start-sqlserver-agent-resource-on-cluster-after-upgrading-to-9-00-3186-or-higher.aspx

I've altered the title. I can see how it upset some people expecting it to contain some SQL magic.

This happens all the time. Anyone that says this doesn't happen in...

I am leaning towards what sturner has written.

Your data pages should not be splitting if you are always adding to the end of the row. However the intermediate pages in...