Repair SQLite Database
Hello,
I have some issues with my SQLite database. The databse itself is encrypted so I am unable to open it with other tools for repair reasons.
Issues:
- Some entries seems to be broken.
- Unable to view some information
- Unable to open properties for all entries
What I need is this datbase repaired or an export, but currently this isn't possible. Can you please help me to repair it? I also have a configured backup in the devolution cloud but I cannot download or access it (I also have no idea when the database broke).
I tried to use the internal manage SQLite file option to repair it but all I get is (Analyze, Vacuum and Repair):
Image already added
All Comments (3)
Hello,
Usually, when you receive the database disk image is malformed error, this means that the SQLite database is probably corrupted.
You mentioned that you have a backup of your sessions, is it our online backup that you have used to backup your sessions?
If yes, you can restore your sessions in a new database by following the steps in this article
https://help.remotedesktopmanager.com/file_backup_restore.htm
Best regards,
Jeff Dagenais
Hello Jeff,
thank you very much for your help. Was very happy to see that the backup has a history.
I was able to restore the last successfull backup which seemed to be created before the database got broken. Currently it seems that I have no losses.
The old database was complete broken and I created a new one. The first thing I did - enabled the Backup function again :-)
Thank you very much for your help!
Just one thing:
The Online backup is not including the documents which are saved directly into the database. Maybe it would be great to have this feature one day :-)
Image already added
Hello,
Glad that everything is working!
Regarding your suggestion, indeed, the documents are not saved in the backup.
I will verify with our engineering department to see if they can add your suggestion to our ToDo list.
Best regards,
Jeff Dagenais