Can a SSAS database be created at a different location than the default
location? If so, how do you do that?

Thanks
Cordelia

You can change the location of the data directoy - look at the DataDir
server property.

--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

Thanks so much, Dejan!

In addition - Cubes, Measure Groups and Partitions also have a "Storage
Location" property where the default server data folder can be
overridden.

Bear in mind that the partition is the base storage mechanism, I think
the setting at the Cube and Measure Group levels mainly serves to set
the default location for the partition(s) they contain.

--
Regards
Darren Gosbell [MVP]
Blog: http://geekswithblogs.net/darrengosbell

*** Sent via Developersdex http://www.developersdex.com ***

Darren, after reading your post, I poked around cubes, measure groups, and
partitions. I only found the storage location property associated with cubes
and, what I believe to be, partitions of the measure group. Measure group
does not seem to have a storage location property. Does that mean storage
location of the initial partition of any measure group is based off the
defined cube storage location?

Thank you for the heads-up on storage location as I am trying to
assign/allocate disk space for a BI server. Are there any other storage types
that are typcially significant large enough that I need to be awared of and
plan for?

Thanks very much for your help!

Cordelia

--
Message posted via http://www.sqlmonster.com

Books OnLine says that Measure Groups have a storage location property.
So either the setting is not exposed for Measure Groups or there is an
error in BOL, either is a possibility.

I thought this may have been where you were heading with your question.
Partitions are the physical unit of storage for the facts which are
typically where the bulk of your storage is used.

Dimensions get physically stored too, but they are typically only a
fraction of the size of your partitions and I can't see where you can
change their storage location anyway.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

Would you happen to know how to redirect all storage locations to a non-
default location or alternatively, to redirect the different types (i.e.
cubes, measure groups, partitions) of storage locations to three different
location? Similar to the DataDir property for the SSAS Database. I was able
to change the DataDir value such that any SSAS Database created subsequent to
the redirection will be created at the new location.

The reason why I want to change the storage location of these objects is
because I'd like to install all the SQL Server 2005 components on the system
drive (c, but the system drive is standardly not where we keep our
application data; hence not a great deal of disk space is allocated to it.
Hopefully, I can identify most if not all the SSAS and SSRS objects that
typically take up a lot of space.

Thanks,
Cordelia

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200611/1

The Data Directory setting at the server level is what you would use to
put all your data on a different drive to the application itself. I
think you will find that once you change this setting that any databases
in the old directory would not be accessible, you would either need to
move the data while the service is not running, or to restore or
re-deploy and process the databases.

I don't think there would be any point in setting the cube, measure
groups and partitions to different locations. My understanding is that
the partition is the primary unit of storage and I believe that the
settings at the cube and measure group merely serve to override the
DataDir setting when new partitions are created. These setting get
inherited from the parent object.

From a storage perspective cubes are just logical containers that have
one or more measure groups. Measure groups are also logical containers
that have one or more partitions. The partition is where the physical
data is stored.

So if you have the following settings:

Server DataDir - d:\

Cube 1 - e:\
Measure Group 1 - f:\
Partition 1 - g:\

You will only have data stored at g:\. If however you create a new
partition in "Measure Group 1", it will be stored at f:\. If you created
a second measure group, its partition would be created on e:\.

If you create a second cube (which will have its own measure group and
partition) and don't change the storage location settings, the data for
the partitions in the second cube would all be on d:\.

--
Regards
Darren Gosbell [MVP]
Blog: http://geekswithblogs.net/darrengosbell

*** Sent via Developersdex http://www.developersdex.com ***

Darren, thanks very much for the information regarding storage. Is there a
way to disable the overriding of DataDir, i.e. all partitions are located at
the specified file path in DataDir?

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200611/1

In article <69486e239e258@uwe>, u28844@uwe says...
I am not aware of a way to disable this, but the default behaviour is to
store everything under the DataDir.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell