copy backup to network
jonwilk
Posts: 32
Hi
I really would like to use this "copy backup to network" feature, however, I want it to copy the backup accross a site-to-site VPN link from a server that isn't part of a domain.
I can access the destination in Windows explorer eg \\192.168.3.122\sqlbackupcopy
however, using this in sql backup doesn't work (the test fails).
I'm guessing it's a security issue, but i'm not sure where to start,
Any ideas?
I really would like to use this "copy backup to network" feature, however, I want it to copy the backup accross a site-to-site VPN link from a server that isn't part of a domain.
I can access the destination in Windows explorer eg \\192.168.3.122\sqlbackupcopy
however, using this in sql backup doesn't work (the test fails).
I'm guessing it's a security issue, but i'm not sure where to start,
Any ideas?
Comments
I suspect (as you do) that your problem is a permissions problem. The account given to the SQL Backup Agent service, needs to have permissions or rights to write to the network share.
Please take a look at the following knowledge base article, as it will most likely answer your question:
Using SQL Backup to back up to a network share
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com