Try it with a different driver and see if you get a better result. Try using 'Microsoft.Jet.OLEDB.4.0' instead of 'Microsoft.ACE.OLEDB.12.0'.

Good to hear that you fixed your problem. Was this backup job that was failing an individual job, or was it part of a DB Maintenance Plan?

If nothing is reported in the SQL error log when the instance starts have you tried just making changes just to the SQL Agent service through SQL Server Configuration Manager...

I agree with Yuri. It could be a statistics issue. How did you reindex the clustered index? If you told the table to rebuild all then you rebuilt any non-clustered...

Well, if you are going from SQL 2005 to 2008 you are going from a BIDS environment to a BIDS environment, so that should be much easier than if you...

What does the maintenance plan history say? It should show the specific step the job failed on with more detailed error information.

I have never installed express edition but I know that other versions of SQL Server 2008 have a window during the install wizard where you identify people/groups that are going...

Ah, okay. I ask because you won't be able to use sys.dm_db_index_usage_stats then since dynamic management objects were not introduced until SQL 2005. You could try using the Index Tuning...

Good you found a solution that works for you. As for your previous post, you would use the try/catch block instead of a trap, not with it. So it would...

Ouch. Sounds like a corrupt file from the error message. How are you trying to run sqlps? From SSMS? Command-line? Shortcut?

Have you tried instead of using a trap using a try/catch block? That way if the code in the try block threw an error you could define in the catch...

Just checking but is this installed on a SQL 2000 instance?

I think the big issue is that a cursor is inefficient for many database operations. When we deal with relational databases the goal (or at least my goal) whever possible...

Take a look at this link:

It seems that a lot of the preemptive wait stat types have not made it to bol yet. It seems from the name that it...

I think what nadabadan posted makes a lot of sense and would probably be the first thing to at least verify before investigating a lot of time in another area.