Backup fail with Operating System Error 3

Application issues
1

Started Full backup and get this error: Failed to backup “Db_V11” database with “Full” backup type: Cannot open backup device ‘C:\Temp\Pranas.NET\SQLBackupAndFTP\backup\Db_V11201711031531.bak’. Operating system error 3(The system cannot find the path specified.)

I do not know what file is required at the mentioned location: the database is located at a remote machine (hosted by my web host provider) and NOT a local SQL Server instance. All Db connection credentials are fine, connection test succeeds.

Within the full log of your backup tool I find something like this:

2017-11-03 14:33:27.7784|TRACE|43|Pranas.NET.SqlBak.Job.Sql.Business.SqlServerHelper|ReadSettingsValue|System.Data.SqlClient.SqlException (0x80131904): You do not have permission to use the bulk load statement.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Pranas.NET.SqlBak.Job.Sql.Business.SqlServerHelper.ReadSettingsValue(DatabaseConnectionInfo connectionInfo, SettingsNode node, String key, String defValue)
ClientConnectionId:f3aeea52-9754-406d-8322-b10868ad44a9
Error Number:4834,State:1,Class:16

But with an older version of the tool it worked without that permission.
Anyone can help, please?

2

Hello,

Please grant LOCAL SYSTEM (or LOCAL SERVICE) account with write/read permissions for C:\Windows\TEMP… folder or specify different temporary folder

Also, please make sure that you have enough free space on your drive.

You can find more details at the following blog post: https://sqlbackupandftp.com/blog/how-to-solve-operating-system-error-3

3

That does NOT help. And: the remote SQL server is at the hosting provider Site within whatever AD Domain: I cannot establish any trust relationship.

4

Sorry, but SQLBackupAndFTP cannot perform remote backups. Please install SQLBackupAndFTP on the same computer where SQL Server is installed.

5

Hi,

Remote backup is rolling out automatically in SQLBackupAndFTP version 11.4.2. If you don’t have it updated yet, just wait a day or two. To do a remote backup, on “Connect” window select “Remote SQL Server” in “Server Type” field.