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.
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.
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