ENHANCEMENT REQUEST - How to set a server's default for the tempdirectory value used by Object (4218674)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

ENHANCEMENT REQUEST - How to set a server's default for the tempdirectory value used by Object
Description

How to set a server's default for the tempdirectory value used by Object Recovery. Allowing the DBA to set the value once instead of the @TempDirectory parameter currently available via script.
Similar to the way that the Server Default settings are stored in HKEY_LOCAL_MACHINE\SOFTWARE\Imceda\SQLLiteSpeed\Engine
Cause

N/A
Resolution

Enhancement request CR81423 has been submitted to Development for consideration in a future release of LiteSpeed.
WORKAROUND:
You can send the files to another directory - both the temporary files and the restored files (there's info in the LiteSpeed Help file):
Utilize @shipdirectory
Name of the ship directory. Use this argument when you want to restore the object later or at a different physical location. This argument creates the following files in the ship directory:
CREATE <object_name>.sql
BULK INSERT <object_name>.sql
<object_name>.fmt
<object_tname>.bcp
To restore the object, run the CREATE file first, and then run the BULK INSERT file. You will need to slightly modify the BULK INSERT file because of the .fmt and .bcp file path names.
,
Also..
@tempdirectory
Temporary directory used for the restore process. Use this argument when the default directory does not have enough free disk space for the restore process.
Defect ID

CR81423

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title