Post reply

SQL 2008 Maintenance Plan

  • September 25, 2008 at 3:51 am

    #194144

    Hi all,

    I just create a SQL 2008 in Active/Passive cluster. Everything is working fine. So i create a maintenance plan to run the schedule backup. There is only one database backup task and nothing else. The maintenance plan created successfully. However, when i right-click the maintanance plan and execute,an error was encountered.

    "Execution failed. See the maintenance plan and SQL Server Agent job history logs for detail."

    Additional Information:

    Job "xx.Subplan_1 failed.(SqlManagerUI)

    But i could not find anything in the SQL Server Agent Error Logs.

    checked the Application log and found a warning entry,

    "SQL Server Scheduled Job 'CSQL.Subplan_1' (0x696AA134DDBE224D89D8F4C622A5CD9F) - Status: Failed - Invoked on: 2008-09-25 17:41:15 - Message: The job failed. The Job was invoked by User L3\administrator. The last step to run was step 1 (Subplan_1)."

    Anyone has any idea what went wrong?

    Thanks in advance

    Ken

  • November 13, 2008 at 9:05 am

    #898158

    I am having the same issue on a sql 2008 cluster.

    Did you ever resolve this error.

    Thanks in advance for your help

  • November 13, 2008 at 9:41 am

    #898183

    Did you guys expand the Job Step detail to see the more-detailed error?

    Also, you can go into Maint. Plan and right-click on the plan, View History

    That one shows detailed error as well

    Just want to know if this is CLUSTER-related

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • November 13, 2008 at 1:09 pm

    #898276

    It turns out i need to have integration Services installed.

    I will do that and get back to the forum.

  • November 17, 2008 at 12:23 pm

    #899497

    OK I cant install ISS on my clustered instance.

    And i found this MSDN article stating that I dont need ISS to run maintenance plans.

    ______________________________________________________________

    These are some of the tasks that you can accomplish even when the Integration Services service is not running:

    Design and run packages in Business Intelligence Development Studio.

    Run packages by using the dtexec command prompt utility (dtexec.exe), the Execute Package Utility (dtexecui.exe), SQL Server Agent, or the SQL Server Import and Export Wizard.

    List packages that are stored in the msdb database by using a Transact-SQL query, and list packages that are stored in the file system by using Windows Explorer.

    **Create and run SQL Server Agent jobs and maintenance plans.

    ___________________________

    http://msdn.microsoft.com/en-us/library/ms345193.aspx

    Does anyone know how to run a maintenance plan without getting the ISS error?

    Thanks,

    Felipe

  • November 17, 2008 at 3:07 pm

    #899590

    My Maintenance Plans are working!!

    I had to install Integration service on the local Instance of each Node.

    **Do not install on the clustered instance. It will give you an error.

    Once I installed it the Maintenance Plan ran without any errors.

    I failed over the clustered instance to test the maintenance plan on each node and it was a success.

    Thanks,

    Felipe

  • November 18, 2008 at 12:06 am

    #899703

    Hi Dear ALL,

    I got the same error message. And the applicaiton log

    was :

    Microsoft.SqlServer.Management.SqlManagerUI.MaintenancePlanMenu_Run_PerformActions()

    Could anyone ever met this kind of situation?

    Thanks in advance.

    Jennifer

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply