Critical Database Errors - Backups Not Available

Started by ms9601, March 02, 2025, 12:33:23 PM

Previous topic - Next topic

ms9601

Got a critical database error on the drive containing my database.  My backups were to the same drive so I have not had any success recovering them.  Suspected a drive error so I wiped and reformatted it and restored the files.  No luck.  I do have backups from the previous version of IMatch but when I try to restore them I'm warned doing so may damage my IMatch installation.

If I'm not able resolve the database error and can't restore a previous version, that most likely leaves me at square one and having to rebuild everything from scratch, but hoping there's some wisdom here that can guide me out of this abyss.

Log file attached.

Thanks.

Mario

QuoteI do have backups from the previous version of IMatch but when I try to restore them I'm warned doing so may damage my IMatch installation.
You mean backups made with Pack & Go? That's good!
The warning about potential damage is because restoring older settings databases, presets and apps on top of a newer IMatch installation will cause harm. But that does not affect the database :)

Restore your latest backup but use the option to store into a different folder. Restoring to a Different Folder
This way your current settings and apps are not affected, since the package is restored into a different folder.
After the package is restored, open the database folder in the target folder and copy the backup database in Window Explorer, replacing your damaged database with a working copy.

QuoteMy backups were to the same drive
Uh-oh. Not a good idea. Backups are made to prevent data loss when a drive dies. Which can happen any time. Always keep backups and original files on different drives. For IMatch backups, even a cheap 128 GB USB stick can hold multiple backups.

Quotesuspected a drive error so I wiped and reformatted it
You are probably right and should no longer trust that drive. It can/will fail again.

ms9601

That seemed to do the trick.  Thank you Mario!

Lesson learned on the backups.  I run a regular backup (with a different application) of several drives and/or folders but I think what happened is the database got corrupted and I was just backing up a corrected db.  I'll make sure to backup my database regularly to a different drive.

The drive in question is a Samsung SSD but I suppose even those are prone to failure too.

Appreciate the help.  I only lost a few months of data which won't be too hard to recreate.

Mario

Quotebut I think what happened is the database got corrupted and I was just backing up a corrected db. 
Pack & Go allows you to perform a database diagnosis for each database you include. To ensure the database is good.
Running a diagnosis frequently is advised and IMatch even does it automatically (when enabled) when IMatch is idle for some time.

Database damage is really rare, and mostly caused by a disk/network defect (even temporarily!) or a hard power failure with disk cache data getting lost and never written.

The real problem is, that database damage can be silent.
The damage may be in rarely used sections of the database, and the database engine can only detect it when it tries to access the data the next time, or during a database diagnosis.

Keep in mind: a backup is no a backup unless you have verified that you can restore it!

A drive that failed once cannot be trusted anymore.
Spinning disks and SSDs die over night, literally. They work fine one one day, but fail to start the next day. Without any particular reason. A SSD can work for 10 years, or fail within the first month.