Is it possible to restore Sonarr from raw database?

[kharkhar]

I have a hard drive that got damaged, and using file recovery software I’ve managed to extract a lot of raw files. I found an sqlite database that seems to contain all of the data that Sonarr needs, however the title or any other attributes has been lost.

The database is 3.6GB in size and contains 27 tables: (blacklist, commands, config, delayprofiles, downloadclients, episodefiles etc). All of the information appears to be there, is there any way for me to use this database to restore Sonarr?

I’ve looked at what was installed in the ProgramData (Windows 7) directory but no obvious databases jump out, the system.data.sqlite file doesn’t seem to be the same as it won’t open in my SQLite editor, so I’m stumped. Any clue what this database that I have would correspond with?

[Taloth]

3.6gb is big, really big. Make a copy, open it in a sqlite editor, run VACUUM;, see if it gets smaller. Unless you have thousands of series I don’t expect it to be bigger than 100 MB.
Btw. the name is C:\ProgramData\NzbDrone\nzbdrone.db, but please note that the database could be corrupt, so no guarantees.

[kharkhar]

Awesome, will try that It IS really big but since the files were recovered from a corrupt hard drive none of the sizes are really matching to reality. I recovered an excel sheet that it says is 500mb and it’s probably no bigger than 150kb for real. If not the back up plan is to just add all of the series by hand and go in and adjust the episodes that need to be downloaded, surely it’s just a question of an hour or two of mucking around, no big deal if the database is corrupt!