Analysis Services: How to move Data folder

(Free Tip, Donate)

·        Make sure that nobody is changing OLAP databases/cubes at the moment

·        Open Analysis Manager

·        Right-click on server name

·        Open Properties and you will be able to see Data folder on General tab (typically c:\Program Files\Microsoft Analysis Services\Data).

·        Copy all files and sub-folders of Data folder to new location (using Command Prompt or Windows Explorer)

·        Go back to Analysis Manager and set path of Data folder to new location

·        Restart Analysis Services

·        Test new setup by querying OLAP databases/cubes

·        If everything is OK, delete original Data folder.