Backup aborted. SQL error "PRAGMA INTEGRITY_CHECK;"

Post here if you have problems installing or using FBackup
Mynarr
Posts: 1
Joined: Thu Feb 01, 2018 2:22 pm

Backup aborted. SQL error "PRAGMA INTEGRITY_CHECK;"

Postby Mynarr » Thu Feb 01, 2018 2:35 pm

I just upgraded from version 6 (I don't recall the exact version number) to version 7.1.301. I had 3 backup jobs in version 6 and all 3 appear to have been successfully imported to version 7. I tried manually running all 3 jobs to make sure they work. 2 of them do work. The third one is giving me an error.

Thanks for your help solving this issue.

Here is the log file for the failed job:
[2/1/2018 8:29:26 AM] FBackup 7.1.301
[2/1/2018 8:29:26 AM] C:\Program Files (x86)\Softland\FBackup 7\bBackup.exe /GUI {11111111-1111-1111-1111-222222222222} /JOB {E3923585-35C4-4F0B-A5AF-F5693E1E408A}
[2/1/2018 8:29:26 AM] Search for "Warning: " and "Error: " to locate warnings and errors in this log file
[2/1/2018 8:29:26 AM] Operating system: Windows 10 Pro (Build 16299)
Processor[0] : Intel(R) Core(TM) i7-3770K CPU @ 3.50GHz
Processor[1] : Intel(R) Core(TM) i7-3770K CPU @ 3.50GHz
Processor[2] : Intel(R) Core(TM) i7-3770K CPU @ 3.50GHz
Processor[3] : Intel(R) Core(TM) i7-3770K CPU @ 3.50GHz
Processor[4] : Intel(R) Core(TM) i7-3770K CPU @ 3.50GHz
Processor[5] : Intel(R) Core(TM) i7-3770K CPU @ 3.50GHz
Processor[6] : Intel(R) Core(TM) i7-3770K CPU @ 3.50GHz
Processor[7] : Intel(R) Core(TM) i7-3770K CPU @ 3.50GHz
Physical memory (free/total) : 27136 MB/31694 MB
User : xxxxx\xxxxx
Admin/BkPriv/RePriv : True/True/True
IsWOW64 : True
Locale : English (United States)
Installed antiviruses:
Windows Defender

[2/1/2018 8:29:26 AM] Opening file "C:\Users\xxxxx\AppData\Roaming\Softland\FBackup 7\FBackup.hst"
[2/1/2018 8:29:26 AM] Starting backup for "Office PC" at 2/1/2018 8:29:26 AM
[2/1/2018 8:29:26 AM] Checking backup destination (Network)
[2/1/2018 8:29:26 AM] Opening file "C:\Users\xxxx\AppData\Roaming\Softland\FBackup 7\Catalogs\Office PC.fkc"
[2/1/2018 8:29:27 AM] Closing file "C:\Users\xxxx\AppData\Roaming\Softland\FBackup 7\Catalogs\Office PC.fkc"
Backup aborted. Reason:
SQL error "PRAGMA INTEGRITY_CHECK;" - database disk image is malformed (11), database disk image is malformed (11) (CAT01)
Next scheduled backup: 2/2/2018 3:30:00 AM
Backup aborted after 1 second(s) at 2/1/2018 8:29:27 AM with 1 error(s), 0 warning(s)
[2/1/2018 8:29:27 AM] Error: SQL error "PRAGMA INTEGRITY_CHECK;" - database disk image is malformed (11), database disk image is malformed (11) (CAT01)
[2/1/2018 8:29:28 AM] Closing file "C:\Users\xxxx\AppData\Roaming\Softland\FBackup 7\FBackup.hst"

Softland
Posts: 1468
Joined: Thu May 23, 2013 7:57 am

Re: Backup aborted. SQL error "PRAGMA INTEGRITY_CHECK;"

Postby Softland » Fri Feb 02, 2018 1:34 pm

Hi,

That backup catalog seems to be corrupt.
Please delete the backup job from FBackup and open the .fkc catalog file from the backup destination to recreate the backup job.
If you still have the problem, please send us the .fkc catalog file to info[at]fbackup[dot]com


Return to “Troubleshooting”