SQL database error

1

Hi Support,

i am using Application version is: “11.3.5”. Trying to backup the database throwing an error message. please find the below in detail.

Failed to backup “XXXX” database with “Full” backup type: Cannot open backup device ‘E:\dbtemp\Pranas.NET\SQLBackupAndFTP\backup\vtvhmain201711221735.bak’. Operating system error 3(The system cannot find the path specified.).
BACKUP DATABASE is terminating abnormally.

  • List item

the SQL user has full rights of the folder & on the services SQL Logon tab this account is enabled login details are correct.
Temp database folder also granted full access. still failing the backups.

Thanks for your support.

Regards,
venkat.

2

Hi Venkat,

Could you please clarify, have you installed SQLBackupAndFTP on the same computer where SQL Server is installed?

3

Hi… i have the same problem
The App is installed in a different server

A:10.10.0.98 - Server with SQLBackUpAndFTP v 11.4.1
B:10.10.0.23 - Server with SQLServer 2005
C:10.10.0.27 - Server NAS with public Temp folder

JOB
Execute in A connecting to B, with destination C
SQLServer: 10.10.0.23
StoreBackUp: \10.10.0.27\Temp\SQL
TemporaryFolder; \10.10.0.27\Temp\

I find in \10.10.0.27\Temp\Pranas.NET\SQLBackupAndFTP\backup\ManagerNet201801191154.bak and then file exist !!!

LOG

19/01/2018 11:54 a.m. Starting job “Backup Job - 2” - “Full”. Computer “MV988”. App v.“11.4.1”
19/01/2018 11:54 a.m. The backup folder is “\10.10.0.27\Temp\Pranas.NET\SQLBackupAndFTP\backup”. The temporary folder is “\10.10.0.27\Temp\Pranas.NET\SQLBackupAndFTP\backup”
19/01/2018 11:54 a.m. Backing up “10.10.0.23” SQL Server databases
19/01/2018 11:54 a.m. Getting maximum file size…
19/01/2018 11:54 a.m. The maximum file size: “”
19/01/2018 11:54 a.m. Backing up “ManagerNet” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
19/01/2018 11:54 a.m. “ManagerNet” database backup successfully completed. Backup type: “Full”
19/01/2018 11:54 a.m. Failed to backup “ManagerNet” database with “Full” backup type: No se pudo encontrar el archivo ‘\10.10.0.27\Temp\Pranas.NET\SQLBackupAndFTP\backup\ManagerNet201801191154.bak’.
19/01/2018 11:54 a.m. Cleaning up backups of “Backup Job - 2” job
19/01/2018 11:54 a.m. Job “Backup Job - 2” finished with “1” errors
19/01/2018 11:54 a.m. Sending job log to it@upsoft.com.ar
19/01/2018 11:54 a.m. Sending report to ${https://sqlbackupandftp.com/weblog?jobid=6fec5c06-50ca-46e9-a334-721af8c2c0f1|Web Log}

4

To resolve this issue please install SQLBackupAndFTP on the same computer where SQL Server is installed.

Currently, SQLBackupAndFTP cannot perform remote backups, but we plan to add this option soon.

5

Ok…
In this version I need one licence per SQL server? or is a bug ?
Thanks

6

Yes, by default one license can be used only on one server.

Please install it on the computer where SQL Server is installed and try again.

7

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.

8

Thanks… I download 11.4.2

Now i have this problem

08/02/2018 11:19 a.m. Starting job “BK Remoto ServerUS5” - “Full”. Computer “MV988”. App v.“11.4.3”
08/02/2018 11:19 a.m. The backup folder is “\10.10.0.27\Temp\Pranas.NET\SQLBackupAndFTP\backup”. The temporary folder is “\10.10.0.27\Temp\Pranas.NET\SQLBackupAndFTP\backup”
08/02/2018 11:19 a.m. Backing up “serverus5” Remote SQL Server databases
08/02/2018 11:19 a.m. Getting maximum file size…
08/02/2018 11:19 a.m. The maximum file size: “”
08/02/2018 11:19 a.m. Backing up “ManagerNet” database to .sql file
08/02/2018 11:19 a.m. Prefetching objects of ManagerNet database
08/02/2018 11:19 a.m. Scripting ManagerNet database
08/02/2018 11:19 a.m. Scripting users and roles of ManagerNet database
08/02/2018 11:19 a.m. Scripting schemas of ManagerNet database
08/02/2018 11:19 a.m. Scripting user defined types of ManagerNet database
08/02/2018 11:19 a.m. Failed to backup “ManagerNet” database with “Full” backup type: This method or property is accessible only while working against SQL Server 2008 or later.
08/02/2018 11:19 a.m. Backing up “ManagerNet_ModuloFacturaElectronica” database to .sql file
08/02/2018 11:19 a.m. Prefetching objects of ManagerNet_ModuloFacturaElectronica database
08/02/2018 11:19 a.m. Scripting ManagerNet_ModuloFacturaElectronica database
08/02/2018 11:19 a.m. Scripting users and roles of ManagerNet_ModuloFacturaElectronica database
08/02/2018 11:19 a.m. Scripting schemas of ManagerNet_ModuloFacturaElectronica database
08/02/2018 11:19 a.m. Scripting user defined types of ManagerNet_ModuloFacturaElectronica database
08/02/2018 11:19 a.m. Failed to backup “ManagerNet_ModuloFacturaElectronica” database with “Full” backup type: This method or property is accessible only while working against SQL Server 2008 or later.
08/02/2018 11:19 a.m. Cleaning up backups of “BK Remoto ServerUS5” job
08/02/2018 11:19 a.m. Job “BK Remoto ServerUS5” finished with “2” errors
08/02/2018 11:19 a.m. Sending job log to it@upsoft.com.ar

My remote server ron SQL 2005…
Exists an option to disable “Full” backup ?? or is not compatible with older versions

Thanks in advance

9

Hi,

Thanks for the details.

This method or property is accessible only while working against SQL Server 2008 or later.

10

Hello,

To resolve the issue, could you please open “Microsoft SQL Server Remote Backup Options” and disabled “User Defined Types”.

SQLBackupAndFTP
SQLBackupAndFTP894×602 45.2 KB

Sorry for the inconvenience.