I am using:
Toad for Oracle Professional (64-bit)
Add-Ons:
17.0.341.1977
I recently encountered an error when Toad was loading. I don't remember the exact error, but I believe it had something to do with not being able to find the tnsnames.ora file. I cancelled and restarted my computer to refresh my connections (I'm working and connecting to the database remotely).
When I got back into Toad and tried to load the workspace I use daily, nothing appeared. It had connections to multiple instances and many editor tabs with various scripts I run throughout the day. None of this appeared.
I loaded some other workspaces I have saved and they all look normal, but the "Daily" workspace remains empty whenever I try to load it.
I went to where I believe the workspace files are stored (C:\Users<myUserName>\AppData\Roaming\Quest Software\Toad for Oracle\17.0\User Files) and looked in the Workspaces.dat file. It looks like the contents for the workspace is indeed missing.
Is there a place where this gets backed up and I can recover from, or is it just gone?
It sounds like what happened is that the error occurred while the workspace was loading. So it was selected but not fully loaded. Then as Toad was shutting down, the workspace was resaved (with nothing). I'll try to reproduce this situation and fix it today.
Toad has an auto-backup system, which is enabled by default, so as long as you never turn that off, then you have some backups.
Look in:
C:\Users\YOUR_WINDOWS_USER_NAME\AppData\Roaming\Quest Software\Toad for Oracle\17.0\User Files Backups
Hopefully you'll find several zip files in there. Do this to recover:
- Shut down Toad if it is running
- Copy workspaces.dat out of the last zip file dated before the problem occurred to `C:\Users\YOUR_WINDOWS_USER_NAME\AppData\Roaming\Quest Software\Toad for Oracle\17.0\User Files\Workspaces.dat'
- Start up Toad
Perfect! Thank you. It's all back.
Looking at the directory structure now, the backup folder should have been obvious, but stress does funny things to your mind. That folder didn't even register.
1 Like
For what it's worth - starting in Toad 24.2 (to be released in the next few weeks), you won't have to dig around in folders to recover something from backup.
You can just go to main menu -> Utilities -> Manage User Settings, then choose what you want to restore from any of those zip files.
Thank you for the information. I'm looking forward to that coming up.
Greg
