I have created a simple Maintence plan to - Check database integrity
- Backup database
On Executing the plan I get a 'Execution Failed' Error
The log for this Maintence plan is as follows - ' Unable to start execution of step 1 (reason: line(1): Syntax error). the step failed. ?
If I manually copy the T-SQL for both steps of the Maintence plan into a new query and execute the query, it completes both steps without error???
we have had more advanced maintence plans working on a schedule for some time without issue. these produce the same error as above.
I am using MS SQL 2005 Management studio ver 9.00.3042.00
Our SQL 2005 server is within my LAN and version 9.0.1399