Change Object Level Recover Temp Directory

Eric Nolen

Is there a way to change the temp directory that the Object Level Recovery feature in SQL Backup 6 uses to restore a table?

The reason I ask is because I filled up the C: Drive while trying to restore a large table.

I found this other post that mentions you can set a new Environment Variable called RGTEMP. Will that work? Is that the only way? Is there a better way?

http://www.red-gate.com/MessageBoard/vi ... php?t=7430

Thanks!

RBA

The TEMP and TMP environment variables should define the directory we use. If you don't want to permanently change the temp dir for all programs then you can open a command prompt to change them just for that one program,

C:\>set temp="e:\mytemp"
C:\>set tmp="e:\mytemp"

and then navigate to the install directory and launch.

No other program will be affected and the setting is lost when the shell terminates, so you might like to do that from a batch file.

Let me know if this doesn't work or is unsuitable and I'll raise it as a bug.