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...
1 post • Page 1 of 1