Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 registry hack For Data Files Storage VS Temp File

Author  Topic 

Cardinalae
Starting Member

3 Posts

Posted - 2002-11-13 : 14:46:49
the following is a registry Hack I found:

If, using Regedit, you look in:
HKEY_LOCAL_MACHINE->Software->Microsoft->OLAPserver:
RootDir
RootDir:Default
TempDir
TempDir:Default

You see that there are two directories specified, the Root and Temp:

You can actually specify a different location for the RootDir than the TempDir (i.e. RootDir "C:\Program Files\MSSQL\Data"
RootDir:Default "C:\Program Files\MSSQL\Data"
TempDir "E:\Data"
TempDir:Default "E:\Data")

Which may be useful if you are wanting to seperate out the space where the cube data is actually stored verses where the temp data is processed.


Forbinscolonel@yahoo.com


Edited by - Cardinalae on 11/13/2002 15:23:16
   

- Advertisement -