+ Reply to Thread
Results 1 to 4 of 4

Backup Maintenance job failing (-1073548784)

  1. Backup Maintenance job failing (-1073548784)

    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: Invalid Parameter". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


    Any ideas why the cleanup is not working, and how to fix this ?

  2. Re: Backup Maintenance job failing (-1073548784)

    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" 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:
    >>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: Invalid Parameter". Possible failure reasons: Problems with the
    >>query, "ResultSet" property not set correctly, parameters not set
    >>correctly, or connection not established correctly.

    >
    > Any ideas why the cleanup is not working, and how to fix this ?



  3. Re: Backup Maintenance job failing (-1073548784)

    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 Task
    > window. It's empty by default and if you leave it empty then you get this
    > error.
    >
    > --
    > Ekrem Önsoy
    >
    >
    >
    > "Hen" 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:
    > >>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: Invalid Parameter". Possible failure reasons: Problems with the
    > >>query, "ResultSet" property not set correctly, parameters not set
    > >>correctly, or connection not established correctly.

    > >
    > > Any ideas why the cleanup is not working, and how to fix this ?

    >


  4. Re: Backup Maintenance job failing (-1073548784)

    Found it:

    Had to fill in the extension, and now the OK button is available.

    "Hen" wrote:

    > 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 Task
    > > window. It's empty by default and if you leave it empty then you get this
    > > error.
    > >
    > > --
    > > Ekrem Önsoy
    > >
    > >
    > >
    > > "Hen" 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:
    > > >>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: Invalid Parameter". Possible failure reasons: Problems with the
    > > >>query, "ResultSet" property not set correctly, parameters not set
    > > >>correctly, or connection not established correctly.
    > > >
    > > > Any ideas why the cleanup is not working, and how to fix this ?

    > >


+ Reply to Thread