November 28, 2010 at 6:09 pm
Hey,
We recently upgraded our SQL server 2000 instance to SQL Server 2008 x86...
I've been able to fix all the other issues that arouse from the upgrade, however I'm still having issues with getting our maintenance jobs to work.
When they're run I get the following error
Executed as user: Domain\Riley. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Now I can only presume that this is an issue with account security, however as this was an upgrade, I would of thought that the job would of thrown the same error whilst we were using SQL 2000 instance, but its only occurred since we upgraded to SQL 2008.
Cheers
November 28, 2010 at 7:35 pm
Just an update, I found that these jobs when to the 'Legacy Database maintenance Plans' folder in the Management folder in SQL Management Studio.
So I Migrated the job and it created the 'Maintenance Plans' folder and created a new job in the Jobs folder... but when I run it I get an error stating that I need 'Intergrated Services" installed.
I take it that the 'Intergrated Services' is required for all maintenance plans? or have I done something wrong?
November 28, 2010 at 10:00 pm
Maintenance Plans are dependent on SSIS until SQL Server 2008 SP1 CU3. This dependency has been taken off starting SP1 CU3. More details here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply