Cannot access temp folder on NAS device

Application issues
1

This would not be an issue if we could backup directly without going through a temp folder. So we tried to use a temp folder on a Synology NAS in the same shared folder that has the backup destination, but that fails with

12/15/2023 5:18:19 AM [Error] Failed to backup “xxx” database with “Full” backup type: Could not find a part of the path ‘T:\temp\Pranas.NET\SBF\5a242825-6bd8-450e-be1c-2b77724ccf25\backup’.

The path T:\temp is a mapped drive with full permissions under the same account that runs SBF. Even manually creating the path it will fail. The temp folder space free check returns

12/15/2023 5:33:08 AM [Info] The backup folder “T:\temp\Pranas.NET\SBF\5a242825-6bd8-450e-be1c-2b77724ccf25\backup” has “” free space.

2

Hello Curtis_Meadow,

We recommend using a local folder as the temporary directory, but you can also try specifying a network path to a NAS starting with two slashes as the temporary folder.

However, it is essential that when using Windows authentication, the user also has write access to this network directory. Alternatively, if SQL Server authentication is used, both the user running the SQLBackupAndFTP (Database Backup) Windows Service and the user running SQL Server must have access to this directory.

Please let us know if you have any other questions.

Thank you for choosing SQLBackupAndFTP.