SQL 2008 Maintenance Plan Execution Error

andy18    SQL-related     SQL 2008 Integration Services Maintenance Plan

I am trying to setup some backup maintenance job for all the databases in the MSSQL 2008 Web edition server today as I have done for previous MSSQL 2005 Workgroup Edition. The entire setup process are exactly we did in SQL 2005 by going through the Management > Maintenance Plan and dragging and dropping the task that you wish to perform.

Well, sometimes things does not goes as you expect . When I tried to execute the maintenance plan to verify the plan was setup and should run as it should be, SQL 2008 throws me an error with some Integration Services error.

Date 3/16/2009 2:13:29 PM
Log Job History (Database Maintenance.MSSQL)

Step ID 1
Server SQLBOX
Job Name Database Maintenance.MSSQL
Step Name MSSQL-Backup-Daily
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: SQL\SQLAccount. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. The SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services. The package execution failed. The step failed.

Oh my god! It needs the Integration Services to be installed for the maintenance plan to be executed successfully. The thing right now is that SQL 2008 Web Edition does not support Integration Services, if you need that, you need the Standard, Enterprise or Developer SQL 2008 Edition to be installed. Microsoft is good in up selling, aren’t they?

Luckily, the SQL 2008 developer team hear the voice and they have released a cumulative update packages at 19 Jan 2009 which corrects the issue addressed. At the Microsoft KB 961126 , the issue has been addressed in very details.

In order to obtain the Hotfixes, you will need to fire up your SQL server client browser – not the one at your local terminal as the links check what edition of Operating System (32bits or 64bits) you are running to send you to download the MSI Hotfixes. You will need to key in your email account and some CAPTCHA code and they will email you a link to download the Hotfixes.

I haven’t tried the Hotfixes at the moment this entry was written as the SQL server is in production and running during office hours. However, I will be trying this during midnight today and will post the updates on the outcome. As usual, make sure you have manually BACKUP all your databases before installing any Hotfixes for disaster recovery purposes!

If you enjoyed this article please consider sharing it!