Note to self...

General Discussion
Post Reply
User avatar
Site Admin
Posts: 320
Joined: Thu May 22, 2014 11:36 am
Location: Wisconsin, USA

Note to self...

Post by DougWilliams » Wed Nov 15, 2017 2:10 am

Note to self.. after testing a SQL Update for someone, be sure to restore your backed up database before doing an Auto-Organize on your images...

I was able to recover, not just from the backup but I had to link the old database (SQL Update tested) and the new database (Auto-Organized image) on the reference field and copied data from one database to the other.

I practice what I preach (backup, backup, backup) and I COULD have recovered from backups but there would have been some pains of other data reconstruction.

I think this is a wake up call for me to have a separate copy of the database JUST for testing the various things CAT users request. I usually just backup, test, restore but I forgot that last step...
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

Post Reply