dbTalk Databases Forums  

Moving Analysis Services Files

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


Discuss Moving Analysis Services Files in the microsoft.public.sqlserver.olap forum.



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

Default Moving Analysis Services Files - 09-24-2004 , 01:44 PM







I need to move Analysis Services files located in default
initial installation location (E:\Program Files\Microsoft
Analysis Services\Data\RDB\Data) to a new drive because
of space issues. Can you please outline the steps for
doing so and any issues to be aware of?

Thanks for your help.
Shaleen

Reply With Quote
  #2  
Old   
Sanka
 
Posts: n/a

Default RE: Moving Analysis Services Files - 09-26-2004 , 08:55 PM






Hi,

Right Click on the Database name, In the General Tab, you
can find the path to Data Folder and Temporary File
Folder. (It should be pointing to E:\Program
Files\Microsoft Analysis Services\Data)

Copy the contents of the "E:\Program Files\Microsoft
Analysis Services\Data" to "D:\Microsoft Analysis
Services\Data" (or your destination folder where you have
lot of space)

Change the path information for Data Folder and Temporary
File Folder in the General Properties of the Database to
point to "D:\Microsoft Analysis Services\Data" (or your
destination folder).

Restart your MS SQL OLAP Services.

HTH.
Cheers,
Sanka


"Shaleen Bawa" wrote:

Quote:
I need to move Analysis Services files located in default
initial installation location (E:\Program Files\Microsoft
Analysis Services\Data\RDB\Data) to a new drive because
of space issues. Can you please outline the steps for
doing so and any issues to be aware of?

Thanks for your help.
Shaleen


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.