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...