When I run it manualy it work ok. As a scheduled job gives an error . I used to work ok for months, nothing changed since. Test connection succeeds .
thanks
run 05-Jan-22 3:00:16 AM by Administrator
SqlBackupAndFtp 10.1.25.41803 Lite at VPS1673899 (Microsoft Windows NT 6.2.9200.0) (.NET: 2.0.50727.4927, 3.0.30729.4926, 3.5.30729.4926, 4.7.3062, 4.0.0.0)
Job name: E:-OneDrive-s1auto-SQL-FTP-sql-backup-ftp.jobx
SUMMARY:
DETAILED LOG:
01/05/2022 03:00:16 ERROR: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
SQL Server: “”.
01/05/2022 03:00:16 ERROR: Job finished (With Errors)
run 04-Jan-22 10:28:58 PM by Administrator
SqlBackupAndFtp 10.1.25.41803 Lite (started manually) at VPS1673899 (Microsoft Windows NT 6.2.9200.0) (.NET: 2.0.50727.4927, 3.0.30729.4926, 3.5.30729.4926, 4.7.3062, 4.0.0.0)
Job name: E:-OneDrive-s1auto-SQL-FTP-sql-backup-ftp.jobx
SUMMARY:
Database S1DATA: Folder - Success, Google Drive - Success
Folder backup: Folder - Success, Google Drive - Success
DETAILED LOG:
01/04/2022 21:30:04 Creating backup of S1DATA to C:-Program Files-Microsoft SQL Server-MSSQL12.SQLEXPRESS-MSSQL-Backup (full)
01/04/2022 21:30:49 Compressing (internal zip, Level: Highest) S1DATA202201042130.bak (Size: 6,907,830 KB) to C:-Users-Administrator-AppData-Local-Temp-2-Pranas.NET-SQLBackupAndFTP-a3zldog1
01/04/2022 21:59:16 Compression completed (archive: “S1DATA202201042130.zip”, size: 708,462 KB)
01/04/2022 21:59:16 Connecting to E:-OneDrive-s1auto
01/04/2022 21:59:16 Uploading S1DATA202201042130.zip to E:-OneDrive-s1auto (S1DATA202201042130.zip)
01/04/2022 21:59:19 Remote file size has been successfully verified
01/04/2022 21:59:19 Disconnecting from E:-OneDrive-s1auto
01/04/2022 21:59:19 Connecting to Google Drive:gropaz gropaz: s1data
01/04/2022 21:59:20 Uploading S1DATA202201042130.zip to Google Drive:gropaz gropaz: s1data (S1DATA202201042130.zip)
01/04/2022 21:59:39 Remote file size has been successfully verified
01/04/2022 21:59:39 Disconnecting from Google Drive:gropaz gropaz: s1data
01/04/2022 21:59:39 Removing S1DATA202201042130.zip from C:-Users-Administrator-AppData-Local-Temp-2-Pranas.NET-SQLBackupAndFTP-a3zldog1
01/04/2022 21:59:39 Compressing (internal zip, Level: Highest) E:-backup to C:-Users-Administrator-AppData-Local-Temp-2-Pranas.NET-SQLBackupAndFTP-a3zldog1-backup202201042159.zip
01/04/2022 22:28:18 Compression completed (archive: “backup202201042159.zip”, size: 1,476,559 KB)
01/04/2022 22:28:18 Connecting to E:-OneDrive-s1auto
01/04/2022 22:28:18 Uploading backup202201042159.zip to E:-OneDrive-s1auto (backup202201042159.zip)
01/04/2022 22:28:22 Remote file size has been successfully verified
01/04/2022 22:28:22 Disconnecting from E:-OneDrive-s1auto
01/04/2022 22:28:22 Connecting to Google Drive:gropaz gropaz: s1data
01/04/2022 22:28:23 Uploading backup202201042159.zip to Google Drive:gropaz gropaz: s1data (backup202201042159.zip)
01/04/2022 22:28:58 Remote file size has been successfully verified
01/04/2022 22:28:58 Disconnecting from Google Drive:gropaz gropaz: s1data
01/04/2022 22:28:58 Removing backup202201042159.zip from C:-Users-Administrator-AppData-Local-Temp-2-Pranas.NET-SQLBackupAndFTP-a3zldog1
01/04/2022 22:28:58 Delete temporary folder: “C:-Users-ADMINI~1-AppData-Local-Temp-2-Pranas.NET-SQLBackupAndFTP-a3zldog1”
01/04/2022 22:28:58 Cleaning E:-OneDrive-s1auto
01/04/2022 22:28:58 Connecting to E:-OneDrive-s1auto
01/04/2022 22:28:58 Cleaning destination folder
01/04/2022 22:28:58 Disconnecting from E:-OneDrive-s1auto
01/04/2022 22:28:58 Cleaning Google Drive:gropaz gropaz: s1data
01/04/2022 22:28:58 Connecting to Google Drive:gropaz gropaz: s1data
01/04/2022 22:28:58 Cleaning destination folder
01/04/2022 22:28:58 Disconnecting from Google Drive:gropaz gropaz: s1data
01/04/2022 22:28:58 Job finished
run 04-Jan-22 3:00:16 AM by Administrator
SqlBackupAndFtp 10.1.25.41803 Lite at VPS1673899 (Microsoft Windows NT 6.2.9200.0) (.NET: 2.0.50727.4927, 3.0.30729.4926, 3.5.30729.4926, 4.7.3062, 4.0.0.0)
Job name: E:-OneDrive-s1auto-SQL-FTP-sql-backup-ftp.jobx
SUMMARY:
DETAILED LOG:
01/04/2022 03:00:16 ERROR: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
SQL Server: “”.
01/04/2022 03:00:16 ERROR: Job finished (With Errors)