Backup on Local/Network drive using Maintenance Plan

Hi,

I have created an sql server 2005 maintenance plan for a daily backup. The plan has two 'Back up database task' i.e. one backup on the local drive while the second on a network drive. When the plan is executed, a backup is created on the local drive but not on the network drive. If i check the log, it says "Access Denied" whereas i have full access to the network drive with complete permissions to read, write and delete.

Can anyone help me understand how to take a backup on both a local and network drive at the same time using a maintenance plan ? I shall be obliged...

Regards...

you have to make sure that the user used to run the maintanence task has sufficient rights on the network share.

Alternatively, you could copy the backup files with a scheduled copy command in windows.. that way, you'll only have to do the backup once in SQL (during backups, your server may suffer a performance hit)

|||

Thanks Erik for the reply, i found one another similar reply. It seems to be a privilige problem...

Regards...

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 ?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:
>>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 ?|||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" <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:
> >>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 ?
>|||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" <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:
> > >>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 ?
> >