If the SQL Backup Agent Windows Service is having issues with accessing files across the domain. The below test will confirm whether the account has permissions to the file in question.
Run the following query in SSMS with the SQL Backup Server Components installed to ensure that the SQL Backup Agent has permissions to the network location (making sure to replace <network location> with the unc path to the network location):
EXECUTE master..sqbutility 999, 'RWE', '<network location>'
If this is successful and the SQL Backup Agent service has read (R), write (W), and execute (E) permissions, the query will return:
<SQBUTILITYRESULT>:1:
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 :
<network location>
If it returns 0, please take a look at the following documentation and ensure your SQL Backup Agent account has the necessary permissions:
6
0
Was this article helpful?
3 out of 6 found this helpful
Articles in this section
- Resolving Error 507 and SQL Error 18456 in PCC Backup Restores
- SQL Backup error 605
- SQL Backup Error: Cannot access resource
- SQL Error 3203
- Error - Cannot load the DLL xp_sqlbackup.dll, or one of the DLLs it references
- Failed to obtain the list of cluster nodes
- Log Copy Queue is stuck in SQL Backup
- SQL Backup Network Share Permissions Test
- SQL Backup troubleshooting
- Errors when running a scheduled job with SQL Backup