scsnet
July 20, 2017, 3:06pm
1
v11.1.13 on Windows Server 2012 R2
I’m trying to run a backup from the command line (as per https://sqlbackupandftp.com/blog/run-sqlbackupandftp-v11-command-line/ ) but nothing happens. No event log, no feedback, nothing at all.
I originally tried using Windows Task Scheduler (which reports Last Run Result 0x0) and then tried from a command line.
The backup job runs fine from the GUI.
Any ideas what might be going wrong here?
Thanks,
Simon
Hi Simon,
Thank you, we’ll add more information when starting a backup job.
scsnet
July 21, 2017, 1:36pm
3
Thank you. Do you have any idea why the command line isn’t doing the backups? Are there any known issues with launching backups from the command line?
We have tested it and everything works properly.
Probably, you may need to run it as administrator.
Also, please clarify do you use Windows Authentication or SQL Server Authentication to connect to SQL Server?
scsnet
July 24, 2017, 8:47am
5
Hi Alexander.
I’ve tried running it from an Administrator elevated command prompt but I still have the same result - no backup and no feedback as to why.
I’m using SQL authentication. The backup job runs fine when using the inbuilt SQLBackupAndFtp scheduler.
Simon
Thank you, we’ll check it.
Alexey
August 12, 2017, 8:31pm
7
Hello,
Please install the latest version of SQLBackupAndFTP 11.1.16. It writes into console all backup log records or error messages. Also, you can check Windows Event Log for messages related to job start/stop.
–
Regards,
Alexey
scsnet
August 14, 2017, 9:19am
8
Hi Alexey,
The Windows Application log messages for scheduled backups or those run from the GUI are working fine.
However, I’m still getting nothing at all from the command line backup. Nothing in the console and nothing the Application log.
Simon
Could you please tell us more details about this issue. What arguments do you use?
scsnet
August 15, 2017, 1:52pm
10
I think I’ve fixed it - one of the parameters was using a different case. Having tested I can now see that all parameters are case sensitive.
Just a thought, but you might want to include some feedback to the console if the CLI command is run with incorrect or missing parameters.
Simon
Thanks for the feedback Simon, we’ll consider your suggestion.
Joseph
April 26, 2018, 1:34am
12
Is there a way to add “With copy_only” to the backup so that a Full Backup does not change the Differential Attributes. Can this be done in the GUI under custom scripts or can it be done with the Command Line.
Thank you
Hi Joseph,
Yes, you can add “Copy_Only” option to backup from a command line, please find more details at How to run SqlBackupAndFtp v11 from a command line | SQLBackupAndFTP's blog
Also, you can find this option at the “Backup option” settings.