Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
steve_rony
Starting Member
7 Posts |
 Posted - 2008-09-22 : 18:44:12
|
| Hi,I have written a maintenance plan for clearing the olda backup files created.When I am executing the plan it gave me the below error "Unable to start execution of step 1 (reason: line(1): Syntax error)".please provide me the suggestions on this..Thanks in Advance,Steve |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-22 : 18:48:53
|
| Tell us steps what you did. |
 |
|
|
steve_rony
Starting Member
7 Posts |
Posted - 2008-09-22 : 20:16:21
|
| Just created the Maintenance Cleanup Task and added constraint to hold only 7 days back up files. Thats all I did.. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-09-23 : 11:31:02
|
| Post the SQL from the maintenance plan you wrote. |
|
|
|
|
|
|
Maintenance plan