Psst! Did you know DevelopmentNow is a mobile web site design agency?

Contact us for help mobilizing your site, or to sign up for our beta Mobile Web SDK!

Reply to "Could i have two folders to keep cubes data in MSAS" on sql server olap:

Your Name  
Email Address
(optional)
NOTE: We will never share your email address with a third party, but your email address
may be displayed publicly on our site next to your post, allowing people see your email
address and contact you. If you do not want your email displayed publicly or seen by other
people, leave this field blank.
Subject  
Message  
Spam Protection
Enter the code into the field below. If you can't read the code, reload the page.
NOTE: DevelopmentNow is an open resource for all techies. Please make your posts relevant
and helpful. We monitor all posts.

Users who repeatedly submit profane or garbage posts may be blocked, banned, and/or
have their ISPs notified for abuse.

Original Thread:

Could i have two folders to keep cubes data in MSAS botinha NO[at]SPAM netcabo.pt
8/25/2004 9:28:33 AM
Hi!
I am wondering if there is a way of having 2 directorys for storage
cubes data?
I have two partitions and i want cubes storage to be split in the two
partitions. Is it possible?
In sql server 2000 i could define two places to keep database data, is
there something like this in AS?

Thanks in advanced!!

Re: Could i have two folders to keep cubes data in MSAS Dave Wickert [MSFT]
8/25/2004 10:49:32 AM
Everything in Analysis Services is driven down from a single folder,
referred to as the "Data Folder". Although this by default is on the same
device as Analysis Services was installed on, but it can be moved to a
different device.

While this folder must exist on a single logical device to NT (e.g. the "F:"
drive), you can use RAID and other hardware technologies to split the data
folder out to multiple physical devices.

--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Could i have two folders to keep cubes data in MSAS Mosha Pasumansky [MS]
8/25/2004 9:24:47 PM
And in Yukon we allow to specify location of files per partition !

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

[quoted text, click to view]

DevelopmentNow Blog