Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wwwebfred
Starting Member
1 Post |
 Posted - 2009-11-18 : 05:16:46
|
| Hi all, I'm having a serious problem with my Maintenance Plans under SQL2008.When I make a MP to backup my Exact databases and put any steps in there (backup or indexing doesn't matter) then I get the following error:Execution failed. See the maintenance plan and SQL Server Agent job history logs for details.Additional information:Job 'MaintenancePlan.Subplan_1' failed. (SqlManagerUI)This MP job is run as domain administrator, same as about 15 others Jobs which do run.As a bonus, when the job fails it doesn't write an errormessage in the SQL logs, it does however write the following in the EventViewer:SQL Server Scheduled Job 'MaintenancePlan.Subplan_1' (0x019B0B092CE242409A5250946EFB8ED1) - Status: Failed - Invoked on: 2009-11-18 10:51:18 - Message: The job failed. The Job was invoked by User domein\Administrator. The last step to run was step 1 (Subplan_1).When I manually run a backup of any of the databases it does work.SQL Services are all run as domain admin.Recovery model Full or Simple doesn't change the outcome.Also removing all MPs and making a new one doesn't do it.Version info:* Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )* Microsoft Analysis Services Client Tools2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )* Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)* Microsoft MSXML 2.6 3.0 4.0 6.0 * Microsoft Internet Explorer 8.0.6001.18702* Microsoft .NET Framework 2.0.50727.3603* Operating System 5.2.3790I've been coping with this problem for over a month now and even the people at Exact who installed everything can't seem to find an answer.Has anyone come accross a problem like this before? Or have any clue on what causes this and how it can be fixed?Your answers will be greatly appriciated. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-18 : 10:58:15
|
| looked at MP log? \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG |
 |
|
|
|
|
|
Error running any MP and any step