Browsing all articles tagged with SQL 2008 Integration Services Maintenance Plan
Mar
16

SQL 2008 Maintenance Plan Execution Error

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. read more