Moving Data Directory of Analysis Services (SQL 2005 / 2008)


Applies to (Data,Backup,Log & Temp)


You cant move Bin and Config Directory Manually, recommended way is Re-Insallation


Here are the steps:


From GUI:


Start Microsoft SQL Server Management Studio, Connect to Analysis Services Server


Right mouse click on server name, then choose properties. Change property “DataDir” to contain new location


Stop Analysis Services Service


Move data to location specified in previous step


Start Analysis Services.


From Config File:


Get the location of Config File of Current Instance.


Open Services.msc, look for Analysis Services Instance, in Path to executable look for the path of Config Directory it will appear something like this:


(“C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Config”)


Stop Analysis Services from Configuration Manager or from SQL Management Studio


Open Config Directory take a backup of existing file – msmdsrv.ini


Using Notepad open Config file (msmdsrv.ini ) and make changes with below mentioned Parameter.


Current Location: <DataDir>C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data</DataDir> to New Location <DataDir>D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data</DataDir>


Copy Data Directory to New Location (Recommendation Don’t Move (Cut and Paste) instead Copy and Paste)


Start Analysis Services


Open Management Studio


Check All Databases are Present


After complete testing you are free to delete Old Directory.

Comments (1)

  1. sql says:

    I want to change DATA, LOG, BACKUP, CONFIG to another drive e.g from S: to F:. It's on cluster, but when I make changes and try to rename folders it says that it's on use. Can you advice me how to do it.