What are the challenges you face when working across database platforms? Take the survey
Options

Change Object Level Recover Temp Directory

Eric NolenEric Nolen Posts: 9
edited September 27, 2009 6:33AM in SQL Backup Previous Versions
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!
-Eric Nolen

Comments

  • Options
    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.
    Robin Anderson
    Development
    Red-Gate Software
Sign In or Register to comment.