Page 1 of 1

Note to self...

Posted: Wed Nov 15, 2017 2:10 am
by DougWilliams
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...