Restoring from a backup seems to repair a corrupted database

Roon Software Discussion
1

Just a question for anyone know knows. I ran into an issue that I had narrowed down to my Roon install. It had to do with specific files erroring out when transcoding in ARC. It was several files and happened for quite a bit. I ended up restoring a database backup taken two days prior while the issue was still present and in spite of that the issues were resovled.

Does anyone know if a database restore also does a database repair as well? I’m just curious for my own knowledge? It was strange that a backup that should have had the same issues ended up solving my transcoding problem.

2

Yes, in that performing a DB restore deletes the old DB files and replaces them with a new set from the backup.

3

It’s just strange that the issue was occuring at the same time as the backup was taken… so the backup would have been affected, but restoring the backup resolved the transcoding errors I was having. Weird!