Lightroom Classic CC lost 5 months of photos in October 2018 update catalog upgrade
I was working on an end-of-the year photo book as a gift for our family, and discovered that I did not have any photos in Lightroom between May 13th and October 31st 2018! This sent me into a panic—how could I loose over five months of photos?
At first, I thought the issue was my fault, that I'd somehow forgotten to import the photos. With young kids and a busy work schedule over the Fall, it was easy to blame myself. In my panic, I downloaded a copy of PhotoRec and sent it to work on my SD card. It was able to recover several hundred of the missing photos from the SD card, which seemed like a miracle.
Over several late nights, I imported the recovered photos, and went through the process of sorting and adjusting them to pick out the best of those months. Then I published them to SmugMug. It was after publishing that I noticed that several of the photos I had just published were already on SmugMug. My workflow is to import photos into Lightroom, sort and adjust them, and upload the best photos to SmugMug.
It was at this point I realized that I had actually imported the photos into Lightroom, however they were no longer in Lightroom. I went looking through my catalog backups and found the following backups where I still had those photos, and where they were lost.
- Had photos from May-October 2018:
- 2018-10-12 0621
- Lightroom Catalog.lrcat
- 2018-10-12 0621
- Missing months of photos:
- 2018-10-24 0848
- Lightroom Catalog-2.lrcat
- 2018-10-24 0848
When I opened the October 12th 2018 backup, I was prompted to upgrade my catalog, and it renamed the catalog Lightroom Catalog-2.lrcat. When I opened the October 24th backup, I was not prompted to upgrade my catalog, and it already had the Lightroom Catalog-2.lrcat name. When I went back and looked at the folder with my primary Lightroom catalog, I see that the last time that the original copy of Lightroom Catalog.lrcat was modified was also on October 24th 2018, and I've been using a Lightroom Catalog-2.lrcat file since then.
So it seems like something went horribly wrong with the original catalog update on October 24th, 2018 and it lost my photos after May. Working backwards, this seems like around the time that I upgraded to the October 2018 release of Lightroom Classic CC. When I opened the older backups and upgraded those catalogs with the newer version of Lightroom Classic (Lightroom Classic version: 8.0 [ 1193777 ]), it seems like all of the photos were preserved from that time period.
Unfortunately, I didn't catch the original upgrade catastrophe in October, and I've been importing new photos since October 24th into the Lightroom Catalog-2.lrcat catalog that got screwed up during the upgrade. The other good news is that it seems like all of the original masters are still on my disk. I should have checked this before panicking.
Now I'm concerned that there might be other photos missing in my catalog that I don't even know about. What's the best way to recover from this Lightroom catalog upgrade catastrophe? Is there anyway to compare my older backup to my newer catalog and see which one has more photos in it?