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...

Interesting. Have you checked SP_who2 and do you see the SQL Agent connected?

Anything in the Agent log?

It almost sounds like the Agent didn't fail over. Have you tried restarting the...

When you say secondary node, I'm not sure what you mean. In A/P, one node is live as the active node. Doesn't matter which one it is.

Did you have a...

One other note, the recovery mode is a database option, not a server option. I believe most db options are not service restarting changes. Some might take the db offline,...