SQL BI

My Experience - Troubleshooting SQL BI Stack

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

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

  • Comments 1

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
  • 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.

Page 1 of 1 (1 items)
Leave a Comment
  • Please add 5 and 6 and type the answer here:
  • Post