Couple of things here. 

1. What does sql agent job indicate as the next time this job is scheduled to run?

2.  Expand the job history and see when it has...

Just a thought but don't pre-create the database.  Just perform a restore db under Enterprise manager, specify the db name you want and then point off to the backup files...

Hiya, not sure what you are describing here.  Go to enterprise manager and check the sql server and sql agent properties and from here determine what windows account is being...

Hmm, not sure.  ok can you check the properties of the alert you have created and ensure that

enabled is ticked.

under response you have selected email for a valid operator.

Also make...

Local system account is a local admin. 

 You should avoid using the method you did for altering the service account.  Go into Enterprise manager and change the service account here instead,...

Couple of things here.  When you say local account do you mean a local machine account or the 'local system account'  which is one of the options presented during the...

Brian, as per my suggestion early on (reboot server) this appears to have worked, can you advise whther this was the first reboot since encountering your problem?  As I said...

Thanks for the final follow-up, I have a few I want to try that on to see if I can remove local admin group membership

Thats great news, why though did the service account not get access to when you changed the service acct via EM.  I thought all privileges would have been set by...

And as an aside, sql server will only use 2 and licensing (if you are using cpu based)  only requires 2.

Good articles

http://support.microsoft.com/kb/263556/EN-US/

http://support.microsoft.com/default.aspx?scid=kb;en-us;315886&sd=tech

Derek

Hi all, I totally agree with comments made by Carl above.  I have had huge issues with this even after following all MS articles. A support call to MS returned...

Agree with Phill, I have used the built in datetime transform when dealing with crap data coming in from an Oracle SAP system.  You can specify a number of formats...

Yeh unlike active /passive which applies the service pack to both nodes automatically.

Yes default on one and named on the other is fine, basically so long as when failover occurs...

Hmm ok lets try to explain.  Your first install was on node1 (dbs06) first what did you call the sql virtual name?  Lets say it was 'sql1' and the instance...