dbTalk Databases Forums  

OLAP Data Files

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


Discuss OLAP Data Files in the microsoft.public.sqlserver.olap forum.



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

Default OLAP Data Files - 01-18-2006 , 10:28 AM






Hi
Could someone tell me where the data files are stored once a cube has been
restored from a CAB?
In much the same way as you can determine where the mdf and ldf files of a
database can be located when i restore , i would also like to determine where
the data for a cube will go.

Regards,
Richard

Reply With Quote
  #2  
Old   
Kaisa M. Lindahl
 
Posts: n/a

Default Re: OLAP Data Files - 01-18-2006 , 10:36 AM






FOr SQL Server 2000 / Analysis Services 2000
In Analysis Manager, right click on your AS Server and click Properties.
The files are stored in the Data folder location on the first tab. (General)

You can change the location by clicking the Browse button and choose a
different location after having installed AS, or you can choose a different
location during setup. If you just go with the default settings when
installing AS; I think the data folder is located at c:\program
files\microsoft analysis services\Data (or something similar).

Kaisa M. Lindahl
"Richard Mabbitt" <RichardMabbitt (AT) discussions (DOT) microsoft.com> wrote in
message news:0C076988-E50A-4AC9-8267-F51CC6A64A16 (AT) microsoft (DOT) com...
Quote:
Hi
Could someone tell me where the data files are stored once a cube has been
restored from a CAB?
In much the same way as you can determine where the mdf and ldf files of a
database can be located when i restore , i would also like to determine
where
the data for a cube will go.

Regards,
Richard



Reply With Quote
  #3  
Old   
Richard Mabbitt
 
Posts: n/a

Default Re: OLAP Data Files - 01-18-2006 , 10:45 AM



Excellent!

Thanks Kaisa


"Kaisa M. Lindahl" wrote:

Quote:
FOr SQL Server 2000 / Analysis Services 2000
In Analysis Manager, right click on your AS Server and click Properties.
The files are stored in the Data folder location on the first tab. (General)

You can change the location by clicking the Browse button and choose a
different location after having installed AS, or you can choose a different
location during setup. If you just go with the default settings when
installing AS; I think the data folder is located at c:\program
files\microsoft analysis services\Data (or something similar).

Kaisa M. Lindahl
"Richard Mabbitt" <RichardMabbitt (AT) discussions (DOT) microsoft.com> wrote in
message news:0C076988-E50A-4AC9-8267-F51CC6A64A16 (AT) microsoft (DOT) com...
Hi
Could someone tell me where the data files are stored once a cube has been
restored from a CAB?
In much the same way as you can determine where the mdf and ldf files of a
database can be located when i restore , i would also like to determine
where
the data for a cube will go.

Regards,
Richard




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.