Dropbox support does not work


#1

trying out your product and pointed “store backups in destinations” to a folder in Dropbox as we need backup offsite. however hit the run now button and app insists on trying to backup to a local file

8/20/2018 9:34 AM Starting job "Backup Job - 1 " - “Full”. Computer “OTS-WS4”. App v.“11.7.3”
8/20/2018 9:34 AM The backup folder “C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ONTHESPOT\MSSQL\Backup” has “36.226GB” free space. The temporary folder “C:\WINDOWS\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup” has “36.226GB” free space
8/20/2018 9:34 AM Backing up “otsserver\onthespot” SQL Server databases
8/20/2018 9:34 AM Getting maximum file size…
8/20/2018 9:34 AM The maximum file size: “10.000GB”
8/20/2018 9:34 AM Backing up “BCS” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
8/20/2018 9:34 AM “BCS” database backup successfully completed. Backup type: “Full”
8/20/2018 9:34 AM Database “BCS” successfully backed up to “C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ONTHESPOT\MSSQL\Backup : unknow”
8/20/2018 9:34 AM Failed to backup “BCS” database with “Full” backup type: Could not find file ‘C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ONTHESPOT\MSSQL\Backup\BCS201808200934.bak’.
8/20/2018 9:34 AM Cleaning up backups of "Backup Job - 1 " job
8/20/2018 9:34 AM Job "Backup Job - 1 " finished with “1” errors

I tested the links to Dropbox from your product and returned successful. Why is trying local operation


#2

Hi John,

It seems you have selected “Remote SQL Server” as a server type at the “Connect to Server” window and tried to connect to your local server. Please choose the correct server type and try again.


#3

no my backup server type is local sql server and as the log says the backup seems to run as one sees these entrys in log:

8/24/2018 2:16 PM “BCS” database backup successfully completed. Backup type: “Full”
8/24/2018 2:16 PM Database “BCS” successfully backed up to “C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ONTHESPOT\MSSQL\Backup : unknow”

then we see
8/24/2018 2:16 PM Failed to backup “BCS” database with “Full” backup type: Could not find file ‘C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ONTHESPOT\MSSQL\Backup\BCS201808241416.bak’.


#4

sorry I read your response wrong and changed the local server to remote and things worked. Thanks


#5

Hi John,

Good news! Thanks for the feedback.

Please feel free to contact us on any issues or concerns.