Can we recover an "sql recall" recent item that was manually deleted?
I.e. using the "Delete selected statement" button.
You can't recover individual SQLs, but the SQL Recall file is automatically backed up, so you can recover it from a recent backup (if it is old enough to be in one of them)
In Toad version 2024.2, you can do this.
Main menu -> Utilities -> Manage User Settings
Click "Recover settings from backup"
Check only "SQL Recall" in the list
Select a backup date/time that you want to recover from
Toad will restart.
If you have an older version of Toad, you can extract SavedSQL.XML from one of these backup zip files manually, then copy it back into your user files folder (while Toad is not running)
The files are in
C:\Users\YOUR_WINDOWS_USER_NAME\AppData\Roaming\Quest Software\Toad for Oracle\24.2\User Files Backups\
1 Like
Thank you very much for taking the time to show those possibilities.