OneDrive for Business Destination error


#1

Hello, we have SQLBackupAndFTP Pro version (12.1.3) and there are also some issues sending backups to OneDrive (Business version). Backups only sometimes can be uploaded to OneDrive. I.e. we have DB with 350MB size and after successful backup process it was uploaded to OneDrive only on 4th upload. Everytime i’ve got these errors:
Destination error: [DST-9:1103#2] Failed to upload “C:\Windows\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup<DB_name.zip>” file to “<DB_backup_folder_name>” folder. > One or more errors occurred. > Code: timeout
Message: The request timed out.
_ > A task was canceled._

Databases which contains much more data (3GB, 6GB) were still not uploaded to OneDrive (I get the same errors and upload process start over again).

Besides, the upload speed is very slow - we have 1Gb/s network speed and software uploads the files only on <300KB/s (but mabye this is OneDrive and Microsoft issue).

Any information would be appreciated!


#2

Hi Karaliaus_M,

Yes, it seems this is OneDrive and Microsoft issue, but we’ll check what we can do from our side.

Sorry for the inconvenience.


#3

Well, if I connect to OneDrive using browser, all files are uploaded at least ~10MB/s. And SQLBackupAndFTP reduces upload speed to 100-500KB/s and with no upload luck.

Edit:
And now i get more errors:
image

Authentication test says “Connection successful”. And here 2/3 DB were uploaded to OneDrive Business (the last one DB backup fail to upload). And the upload speed is poor.
Let me know if you’ll find any useful tips.


#4

Hi Karaliaus_M,

Thanks for the details.

We can confirm that we have moved OneDrive from Rest API to Graph API using Microsoft’s instructions.

If you still have this issue, please try to reauthorize to your OneDrive.

If you use OneDrive for Business as a destination place please make sure you authorize using the correct account (OneDrive for Business).

Sorry for the inconvenience.


#5

Hello,

I am having a problem with OneDrive for Business when Test the Connection. refer below

ErrorinSQLbackup

i really need to used the OneDrive for Business.

please advice,


#6

Hi John,

Thanks for the details.

Please specify just the folder’s name, not a link. Here are more details on how to set a backup job and send backups to OneDrive for Business https://www.youtube.com/watch?v=YGj8SFHJGwk