During SQLBACKUPANDFTP Job we have this error:
"• 1:21:20 AM : Uploading local “PLSPMO202405272334.bak” to remote “PLSPMO202405272334.bak” in folder “/plspmo”.
• 1:38:51 AM : WARNING: Destination error: incorrect_offset/…
• 1:38:51 AM : Trying again…
• 4:48:41 AM : WARNING: Destination error: incorrect_offset/…
• 4:48:41 AM : Trying again…
• 5:38:52 AM : WARNING: Destination error: incorrect_offset/…
• 5:38:52 AM : Trying again…
• 9:38:53 AM : WARNING: Destination error: incorrect_offset/.
• 9:38:53 AM : Trying again…
• 1:38:53 PM : ERROR: Destination error: Failed to upload “C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup\PLSPMO202405272334.bak” file to “PLSPMO” folder. > incorrect_offset/…
• 1:38:53 PM : Disconnecting from “Dropbox” destination “DATACH DATACH”.
"
Hello DATACH_TECHNOLOGIES,
We occasionally observe such errors with our clients, which may be attributed to network issues. Could you please clarify if this error occurs regularly or only once?
Please let us know if you have any other questions.
Thank you, and sorry for the inconvenience.
Hi,
We also get this error when setting dropbox as the target location.
It looks like the error occurs as soon as the back-up size exceeds 100GB.
Oleg
December 16, 2024, 1:58pm
4
Hello,
Thank you for your message.
For guidance on backing up large databases, please refer to our recommendations in the following article:
Backup Large Databases with SQLBackupAndFTP .
I am getting a destination error with Dropbox as a destination with a file size of 27MB. Why?
Oleg
February 4, 2025, 10:51am
6
Hello Jim,
Thank you for your message.
We have addressed your case in another conversation. You can find the details here:
Uploading to Dropbox Destination Error