SQL logic error no such table: BackupLocalFile

Application issues
1

Hi,
My program just stopped making bakups.
I have 2 jobs configured. In both of them I get the following error:

“ERROR: Failed to backup “fk6plus” database with “Full” backup type: Local routines database error. Method: “SaveLocalBackupFile”. Message: SQL logic error no such table: BackupLocalFile”

I run 12.2.1 version with Lite license on Windows 10 machine.

2

Hi Powiatowa_Stacja_San,

To resolve the issue, could you please run the sbf-new_routines (https://www.dropbox.com/s/84xt9a87l82h6mi/sbf-new_routines.bat?dl=0) file as Administrator.

Please let us know if you have any further questions.

Sorry for the inconvenience.

3

Now it works fine again, thank you for your help.

4

Hi Powiatowa_Stacja_San,

That’s great! Thank you for your reply.

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

5

I have the same issue. can you help me?
The backcup was working fine but we switch the VM on another machine and the problem start.
I,M able to do a manual backup in sql server,

6

Hi Gontran_Harvey,

To resolve the issue please do the following:

  1. Uninstall SQLBackupAndFTP
  2. Remove the following directory C:\ProgramData\Pranas.NET\SQLBackupAndFTP\
  3. Install the application
  4. Tune the backup job

Note, as a result, all your backup jobs and settings will be removed and you have to create backup jobs again.

Sorry for the inconvenience.

7

I’m gettin exactly the same error. It’s possible to fix it without re-installation?

8

Hi Roman_Safranek,

Could you please let us know, what version of the application do you use?

Yes, it is highly recommended to path the steps described in the reply above to resolve the issue.

Sorry for the inconvenience.