Hi,
I have created a maintenance job that fails at cleaning up the old backup
files. Messages of the Maintenance job are:
Task detail:
>Maintenance Cleanup on Local server connection
>Cleanup Database Backup files
>Age: Older than 3 Days
Error Number:
>-1073548784
Error Message:
>Executing the query "EXECUTE master.dbo.xp_delete_file 0,N'',N'',N'2007-12-
09T11:00:24'
>" failed with the following error: "Error executing extended stored procedure: Inva
lid Parameter". Possible failure reasons: Problems with the query, "ResultSet" prope
rty not set correctly, parameters not set correctly, or connection not established c
orr
ectly.
Any ideas why the cleanup is not working, and how to fix this ?Ensure that you defined a Folder path in the Define Maintanence Cleanup Task
window. It's empty by default and if you leave it empty then you get this
error.
Ekrem ?nsoy
"Hen" <Hen@.discussions.microsoft.com> wrote in message
news:F3B48F39-727F-4364-872D-472A4F0972E7@.microsoft.com...
> Hi,
> I have created a maintenance job that fails at cleaning up the old backup
> files. Messages of the Maintenance job are:
> Task detail:
> Error Number:
> Error Message:
> Any ideas why the cleanup is not working, and how to fix this ?|||The path is indeed empty. When I try to modify/edit the database maintenance
cleanup task, the dialogs let me fill in a path but the OK button remains
greyed out. Is there a special procedure required to edit this ?.
"Ekrem ?nsoy" wrote:
> Ensure that you defined a Folder path in the Define Maintanence Cleanup Ta
sk
> window. It's empty by default and if you leave it empty then you get this
> error.
> --
> Ekrem ?nsoy
>
> "Hen" <Hen@.discussions.microsoft.com> wrote in message
> news:F3B48F39-727F-4364-872D-472A4F0972E7@.microsoft.com...
>|||Found it:
Had to fill in the extension, and now the OK button is available.
"Hen" wrote:
[vbcol=seagreen]
> The path is indeed empty. When I try to modify/edit the database maintenan
ce
> cleanup task, the dialogs let me fill in a path but the OK button remains
> greyed out. Is there a special procedure required to edit this ?.
>
> "Ekrem ?nsoy" wrote:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment