I am trying to backup a database just using the Maintenance plan. I want to backup the transaction logs every hour and the database daily and once backedup delete the previous backup. The problem being I keep getting an error saying "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.". However it has worked in the past.
Can someone please help.
