Thank you for your forum post.
Despite and I quote:
That folder has read/write permission for "Everyone" and folder is browse from "Network Share"'s browse button only.
The error message does indicate that the account given to the SQL Backup Agent does not have security permissions to the network share folder.
Run the following query to ensure that the account has sufficient given to the SQL Backup Agent has permissions on the network share:
- Code: Select all
EXECUTE master..sqbutility 999, 'RWE', '<network location>'
Replace <network location> with the unc path to the network share.
If this is successful and the SQL Backup Agent service has read (R), write (W), and execute (E) permissions, the query will return:
If there is a problem, the query will return a value of 0, followed by a message, for example:
<SQBUTILITYRESULT>:0:Folder does not exist :