Can real-time backup corrupt zotero.sqlite?

edited December 14, 2018
If I set real-time backup tool to backup data folder after 30 seconds of idle time while I run Zotero, can this corrupt zotero.sqlite?


Thanks in advance.

  • Backup tools don't modify the files they back up, so no, that shouldn't be possible.

    It's possible, though, that it could back up the file while it's in an inconsistent state, such that a restored database would be corrupt. But as long as you're doing regular, automated backups, you should have a recent version that works and shouldn't worry about it. (And the backups of Zotero's automatic backups — e.g., zotero.sqlite.bak — will always be stable.)
  • Thanks for your answer.

    One more question:

    You said, the backups of Zotero's automatic backups — e.g., zotero.sqlite.bak — will always be stable.

    Does this mean Zotero always backup stable sqlite file?
    That is, if zotero.sqlite file gets corrupted, Zotero doesn't make the backup of if?

    I have used Zotero for 7 years without any error. However, nowadays my zotero.sqlite file sometimes gets corrupted. As a result I have lost some of my recent contents.

    I don't think it is due to the instability of Zotero. It may be due to my computer system(Windows 10+data folder in external HDD), because the error appeared after I started to use Windows 10.

    I'm checking everything to find out causes. In the meantime, I will use real-time backup tool to prevent data losses.
  • Does this mean Zotero always backup stable sqlite file?
    It means Zotero closes the database safely before making the automatic backup, and since the backup file isn't touched after that it won't be in use when the external backup runs.

    But it's still just a copy of the file, so if your active database is actually corrupted, the corrupted file will be copied.

    The most likely cause of corruption on an external drive would be unmounting the drive while Zotero is open.
  • edited December 15, 2018
    Thanks.
Sign In or Register to comment.