Applies to (Data,Backup,Log & Temp)
You cant move Bin and Config Directory Manually, recommended way is Re-Insallation
Here are the steps:
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.
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.