Feel bad asking this....

Toad for Oracle
1

…I know this has been asked before (many, many times), but I can’t find it.

One of our DBAs lost their hard drive & didn’t have their TOAD files backed up.
We are implimenting a scheduled backup using FBackup so this doesn’t happen
again.

My question is, where is the document that lists what files/directories contain
all of the user settings, SQL, etc?

BTW - We are on TOAD 10.1

Again, my apologies for asking this age old question again!

2

It’s under Documents & Settings\Application
Data\Quest…\Toad

Just restore that entire directory if possible.

3

Not sure if I shared this before, but I created a number of .bat files that I
put in Programs / Startup that copies the user files to the network everytime I
log in. I made it generic enough that it will work for everyone.

Toad 10 backup: (toad10backup.bat)

echo Hello %USERNAME%
echo Backing up Toad files to h:\ca\common\toadbk%USERNAME%%COMPUTERNAME%_10
mkdir “h:\ca\common\toadbk%USERNAME%%COMPUTERNAME%_10\User Files”
xcopy “C:\Documents and Settings%USERNAME%\Application Data\Quest Software\Toad
for Oracle\10.0\User Files”
“h:\ca\common\toadbk%USERNAME%%COMPUTERNAME%_10\User Files” /i/e/y/d/m

9.7 backup: (toad97backup.bat)

echo Hello %USERNAME%
echo Backing up Toad files to h:\ca\common\toadbk%USERNAME%%COMPUTERNAME%_97
mkdir “h:\ca\common\toadbk%USERNAME%%COMPUTERNAME%_97\User Files”
xcopy “C:\Documents and Settings%USERNAME%\Application Data\Quest Software\Toad
for Oracle\9.7\User Files” “h:\ca\common\toadbk%USERNAME%%COMPUTERNAME%_97\User
Files” /i/e/y/d/m

of course you would have to change h:\ca\common\toadbk to some shared network
drive in your company

Ian

4

Thanks Jeff.

I have 10.1.1.8 installed, but don’t see a 10.1 directory. Is TOAD 10.1 using
the 10.0 directory?

5

Could be – check the file date of your .ini files, if they are from today when
you used 10.1, then yeah.

Also check the Application Data Directory setting in your options