dbTalk Databases Forums  

Could i have two folders to keep cubes data in MSAS

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Could i have two folders to keep cubes data in MSAS in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Botinha
 
Posts: n/a

Default Could i have two folders to keep cubes data in MSAS - 08-25-2004 , 11:28 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!!

André Fonseca

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Could i have two folders to keep cubes data in MSAS - 08-25-2004 , 12:49 PM






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 (AT) online (DOT) 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.

"Botinha" <botinha (AT) netcabo (DOT) pt> wrote

Quote:
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!!

André Fonseca



Reply With Quote
  #3  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: Could i have two folders to keep cubes data in MSAS - 08-25-2004 , 11:24 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.
==================================================

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Quote:
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 (AT) online (DOT) 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.

"Botinha" <botinha (AT) netcabo (DOT) pt> wrote in message
news:9587965.0408250828.10554c5f (AT) posting (DOT) google.com...
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!!

André Fonseca





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.