I have SQL Server 2008, My Maintenance plan for backup(Full, Diff and Log) has been failing from last two days. There are 33 DB (Including system db). Whenever i go to edit my maintenance plan its giving me an error "The task requuires connection to be initialised". After I click to "OK" Its allowing me to editing maintenance plan but I am not able to see any DB in the list at mainenance plan window ! I found that there are about 3 DB whose status has been changed to restored, but there is an option that we can exclude DB whose state is not online. i tried it too but still no luck.
Can anyone help me to understand why its failing and how to recover from this error ?
Thanks in advance.