Hi,
I’ve created a backup on the QNAP NAS. The connection test passes successfully. When backing up - the first one is unsuccessful. Error message - an improper user name or password. When I click after a moment, make a backup, the whole process goes without a problem. Then after a minute I run the copy again and again I have a problem with authentication.
Could you please open your “Local/Network folder/Nas Settings” window and make sure that you have specified your User Name like “domain/user name”.
The credentials I have entered correct. Except that when I make the connection test for the first time, I have the wrong username or password information. Then I click the connection test again and everything is ok.
Then when it starts backing up 2 sql databases to the same network location. This one goes normally, and the other one I deny access to the folder even though they are in the same folder.
Log poniżej.
03.03.2018 08:35 Starting job “NAS TEST” - “Full”. Computer “SSQL01”. App v.“11.5.2”
03.03.2018 08:35 The backup folder “D:\SQL\Backup” has “120,679GB” free space. The temporary folder “C:\Windows\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup” has “87,070GB” free space
03.03.2018 08:35 Backing up “.” SQL Server databases
03.03.2018 08:35 Getting maximum file size…
03.03.2018 08:35 The maximum file size: “”
03.03.2018 08:35 Backing up “ERPXL_B” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
03.03.2018 08:35 Verifying “ERPXL_B” database backup
03.03.2018 08:35 "ERPXL_B database backup successfully completed. Backup type: “Full”
03.03.2018 08:35 Database “ERPXL_B” successfully backed up to “ERPXL_B201803030835.bak : 154,145MB”
03.03.2018 08:35 Compressing “ERPXL_B201803030835.bak” file with Internal archiver. Encryption: “Off”
03.03.2018 08:35 Backup of “ERPXL_B” successfully compressed to “(ERPXL_B2-1803030835.zip : 14,509MB)”
03.03.2018 08:35 Backing up “ERPXL_V” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
03.03.2018 08:35 Verifying “ERPXL_V” database backup
03.03.2018 08:35 “ERPXL_V” database backup successfully completed. Backup type: “Full”
03.03.2018 08:35 Database “ERPXL_V” successfully backed up to “ERPXL_V201803030835.bak : 113,121MB”
03.03.2018 08:35 Compressing “ERPXL_V201803030835.bak” file with Internal archiver. Encryption: “Off”
03.03.2018 08:35 Backup of “ERPXL_V” successfully compressed to “(ERPXL_V201803030835.zip : 10,121MB)”
03.03.2018 08:35 Connecting to Folder destination “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Destination error: [DST-1:1003#1326] Failed to open “\192.168.1.20\backup_srv\ssql01\db\test” destination connection. > Nazwa użytkownika lub hasło są niepoprawne
03.03.2018 08:35 Connecting to Folder destination “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Reading folder information by path: “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 The current destination folder is “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Sending backup of “ERPXL_V” to Folder destination “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Uploading local “ERPXL_V201803030835.zip” to remote “ERPXL_03.03.2018 08:35 Starting job “NAS TEST” - “Full”. Computer “SSQL01”. App v.“11.5.2”
03.03.2018 08:35 The backup folder “D:\SQL\Backup” has “120,679GB” free space. The temporary folder “C:\Windows\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup” has “87,070GB” free space
03.03.2018 08:35 Backing up “.” SQL Server databases
03.03.2018 08:35 Getting maximum file size…
03.03.2018 08:35 The maximum file size: “”
03.03.2018 08:35 Backing up “ERPXL_B” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
03.03.2018 08:35 Verifying “ERPXL_B” database backup
03.03.2018 08:35 “ERPXL_B” database backup successfully completed. Backup type: “Full”
03.03.2018 08:35 Database “ERPXL_B” successfully backed up to “ERPXL_B201803030835.bak : 154,145MB”
03.03.2018 08:35 Compressing “ERPXL_B201803030835.bak” file with Internal archiver. Encryption: “Off”
03.03.2018 08:35 Backup of “ERPXL_B” successfully compressed to “(ERPXL_B201803030835.zip : 14,509MB)”
03.03.2018 08:35 Backing up “ERPXL_V” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
03.03.2018 08:35 Verifying “ERPXL_V” database backup
03.03.2018 08:35 “ERPXL_V” database backup successfully completed. Backup type: “Full”
03.03.2018 08:35 Database “ERPXL_V” successfully backed up to “ERPXL_V201803030835.bak : 113,121MB”
03.03.2018 08:35 Compressing “ERPXL_V201803030835.bak” file with Internal archiver. Encryption: “Off”
03.03.2018 08:35 Backup of “ERPXL_V” successfully compressed to “(ERPXL_V201803030835.zip : 10,121MB)”
03.03.2018 08:35 Connecting to Folder destination “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Destination error: [DST-1:1003#1326] Failed to open “\192.168.1.20\backup_srv\ssql01\db\test” destination connection. > Nazwa użytkownika lub hasło są niepoprawne
03.03.2018 08:35 Connecting to Folder destination “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Reading folder information by path: “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 The current destination folder is “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Sending backup of “ERPXL_V” to Folder destination “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Uploading local “ERPXL_V201803030835.zip” to remote “ERPXL_V201803030835.zip” in folder “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Uploaded 100 % (average speed = 54,1 MB/s)
03.03.2018 08:35 Verifying remote file “ERPXL_V201803030835.zip” with local one “ERPXL_V201803030835.zip”
03.03.2018 08:35 Cleaning up backups of “NAS TEST” job
03.03.2018 08:35 Cleaning up backups of “ERPXL_V” database at Folder destination “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Disconnecting from Folder destination “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Job “NAS TEST” finished with “1” errors
201803030835.zip” in folder “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Uploaded 100 % (average speed = 54,1 MB/s)
03.03.2018 08:35 Verifying remote file “ERPXL_V201803030835.zip” with local one “ERPXL_V201803030835.zip”
03.03.2018 08:35 Cleaning up backups of “NAS TEST” job
03.03.2018 08:35 Cleaning up backups of “ERPXL_V” database at Folder destination “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Disconnecting from Folder destination “\192.168.1.20\backup_srv\ssql01\db\test”
03.03.2018 08:35 Job “NAS TEST” finished with “1” errors
03.03.2018 08:35 Sending report to ${https://sqlbackupandftp.com/weblog?jobid=42f1cd60-6e8d-4259-82fb-bcf0bd7c58e5|Web Log}
Thank you for the detail log. To resolve this issue, please specify the correct path starting from “\” - \\92.168.1.20\backup_srv\ssql01\db\test