Joie Andrew (12/5/2012)

---

Hemant.R (12/5/2012)

--------------------------------------------------------------------------------

but if you are running maintainance plan for backup job then it is necessary that intergartion service in running state .

if it not started then your job will fail.

If that was true, then you should not be able to schedule maintenance plans for your database backup\maintenance activities if you didn't install Integration Services.

- Divine Flame

It is easy enough to verify that it is not true. Look at an instance of SQL without Integration Services installed. There should not be any Intergration Services service listed in SQL Server Configuration Manager yet you can still create and run Maintnenance Plans.