cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Want to know all about tools for creatives that work seamlessly with Dropbox, like Adobe? Well, check it out right here!

Dropbox installs & integrations

Connect your tools and content together with help from the Dropbox Community. Join a discussion or post a question of your own to get started.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQLBak to Dropbox backup - transport connection error

SQLBak to Dropbox backup - transport connection error

arkroyal
Helpful | Level 5

I use SQLBak to backup several MS SQL Server DBs to an internal NAS device and then copy the backups to a shared Dropbox folder for disaster recovery purposes. Seven days ago, ALL of my SQLBak backup jobs to Dropbox started failing with the error message below. I have already raised a ticket with SQLBak and they confirmed that it does not appear to be an issue with the SQLBak agent and suggested that a change to Dropbox may have caused it. Anyone got any ideas?

[DST-4:1103#2] Failed to upload "C:\Windows\TEMP\SqlBakTestFile.bak" file to "gollum" folder. > One or more errors occurred. > An error occurred while sending the request. > The underlying connection was closed: An unexpected error occurred on a send. > Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. > An existing connection was forcibly closed by the remote host

1 Accepted Solution

Accepted Solutions

Re: SQLBak to Dropbox backup - transport connection error

arkroyal
Helpful | Level 5

Tried unlinking and relinking and got a warning message that the old version of Dropbox platform is being retired on Sept 28 2017 (stet) and the developer has yet to acknowledge the change, so this app may not continue to work in the future. I have also tried the latest version of the SQLBak agent (2.12.7). Still no luck, so I think I will refer back to SQLBak.

 

View solution in original post

13 Replies 13

Re: SQLBak to Dropbox backup - transport connection error

Walter
Dropboxer

Hey there @arkroyal - sorry to hear about this.

To begin with now, could you send a screenshot of the exact error you get please?

Also, do you get the same error when trying to copy these backups on other locations maybe? 

Thank you in advance for any additional information you think might help our investigation. 


Walter
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
:arrows_counterclockwise: Still stuck? Ask me a question!
:pushpin: Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Re: SQLBak to Dropbox backup - transport connection error

arkroyal
Helpful | Level 5

@Walter wrote:

Hey there @arkroyal - sorry to hear about this.

To begin with now, could you send a screenshot of the exact error you get please?

Also, do you get the same error when trying to copy these backups on other locations maybe? 

Thank you in advance for any additional information you think might help our investigation. 


Screenshot below. All of the DB backups to Dropbox fail with the same error. I only use our NAS device as another backup location and that works fine.


Selection_915.jpg

Re: SQLBak to Dropbox backup - transport connection error

Walter
Dropboxer

Thank you for the additional information @arkroyal - most appreciated.

From what you mentioned, I understand that the setup you are using has the Dropbox folder on a NAS drive.

As this Help Center article outlines, the Dropbox folder should not be installed on a Network Attached Storage (NAS) drive. Read on for more context:

Dropbox could be presenting this behavior because network file systems do not send messages when files change. When Dropbox first starts it will do a deep file scan and will detect changes and sync them. However, during normal operation, Dropbox waits for "file update events" and only physically connected drives send these events. 

The best fix to this problem is simply to move the Dropbox folder to a computer's internal drive.  

I strongly recommend choosing a location on the same hard drive as your operating system while also making sure that it's on a supported format. Dropbox won't work correctly should the Dropbox folder ever become inaccessible.

I know it's not much but I sure hope this information helps to some extent. If there's anything else I can help with from my end, do let me know. 


Walter
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
:arrows_counterclockwise: Still stuck? Ask me a question!
:pushpin: Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Re: SQLBak to Dropbox backup - transport connection error

arkroyal
Helpful | Level 5

Thanks Walter, but just to confirm I do NOT have the Dropbox folder on a NAS device. I backup the DBs to a shared folder on an internal NAS device first and then to a folder in my Dropbox Business account as the secondary location. The backups are failing when attempting to backup DBs to the Dropbox folder. Been working fine up until about a week ago.

Re: SQLBak to Dropbox backup - transport connection error

Rich
Super User II

@arkroyal wrote:

I backup the DBs ... to a folder in my Dropbox Business account as the secondary location. The backups are failing when attempting to backup DBs to the Dropbox folder.


Do you have the Dropbox client installed and syncing normally, with SQLBak saving directly to the local Dropbox folder on your computer (which Dropbox then syncs to the cloud), or does SQLBak link directly to your Dropbox account online, bypassing your local drives completely?

According to this page, it looks like SQLBak uses the Dropbox API to connect and save backup files directly to your Dropbox account online, bypassing any local storage. If that's the case, then you'll need to go back to SQLBak for support. Only they will be able to provide support for a process that they've created. Dropbox cannot support third-party applications. If SQLBak is unable to determine or correct the problem, they'll need to contact Dropbox Support themselves.

Re: SQLBak to Dropbox backup - transport connection error

arkroyal
Helpful | Level 5

SQLBak does use the Dropbox API and links directly with our online Dropbox account. I will check with SQLBak again. Maybe rolling back the SQLBak agent or waiting until the next release will resolve it.

Re: SQLBak to Dropbox backup - transport connection error

Walter
Dropboxer

Sorry to interfere here @arkroyal (as I won't be able to help further at this point since it's not within my scope of expertise); have you by any chance try unlinking SQLBak from your account's connected apps tab and linking it anew? 

In any case, please keep us posted! 


Walter
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
:arrows_counterclockwise: Still stuck? Ask me a question!
:pushpin: Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Re: SQLBak to Dropbox backup - transport connection error

arkroyal
Helpful | Level 5

Tried unlinking and relinking and got a warning message that the old version of Dropbox platform is being retired on Sept 28 2017 (stet) and the developer has yet to acknowledge the change, so this app may not continue to work in the future. I have also tried the latest version of the SQLBak agent (2.12.7). Still no luck, so I think I will refer back to SQLBak.

 

View solution in original post

Re: SQLBak to Dropbox backup - transport connection error

JohnnyTq
Explorer | Level 4

Hello .

I have the same problem and i want to know if you got the solution .

Thank you

Poll
Do you work or study in the creative industry? If so, which area?
If you use Adobe, don't forget to check out our latest integrations update here.
Who's talking

Top contributors to this post

  • User avatar
    arkroyal Helpful | Level 5
  • User avatar
    JohnnyTq Explorer | Level 4
  • User avatar
    Rich Super User II
What do Dropbox user levels mean?
Need more support?