• Hi,

    Great job, I was develop a symilar way, but encounter error whem copy to network drive.

    I was set the permissions to everyone, change the user for SQL Agent, try to put this user in Administrator Group and nothing.

    Always the job in sql command say:

    move /Y \\backup\aaaa_20100927.bak \\192.168.10.1\BACKUPS\bbbb.bak

    output

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Access is denied.

    Any Ideas?