Monday, March 12, 2012

Maint Plan dont delete the .bak files?

Hello
I have made maint cleanup task, that delete .bak files, but i got this
error, i know there is .bak files in that dir.
xp_delete_file() returned error 2, 'The system cannot find the file
specifiedHi CK!
You see that error because the file you specified to be deleted by the Job
is already deleted. It's not exist in that path you specified while you were
setting up the task.
Check out the path you specifed and see yourself. I think you specified a
specific path for a certain file, not for a folder. The "Delete specific
file" and "File name" in the "Define Maintenance Cleanup Task" window when
you were setting up your maintenance task.
To delete *.bak files in a folder, you should choose "Search folder and
delete files based on an extension" Choose the folder and type the file
extensin in the "File extension" edit box.
Ekrem Önsoy
"CK" <fhf@.ggg.lo> wrote in message
news:C330FDC3-7F24-40B4-BE1C-D2E7FCCB956D@.microsoft.com...
> Hello
> I have made maint cleanup task, that delete .bak files, but i got this
> error, i know there is .bak files in that dir.
> xp_delete_file() returned error 2, 'The system cannot find the file
> specified

No comments:

Post a Comment