How to relocate the msmdsrv.ini file for OLAP

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » How to relocate the msmdsrv.ini file for OLAP...

How to relocate the msmdsrv.ini file for OLAP

Rate Topic

Display Mode

Topic Options

Author

Message

Larry Kruse

Posted Thursday, February 21, 2013 7:16 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 11:54 AM
Points: 90, Visits: 584

We recently purchased a high-performance SAN and I'm in the process of migrating stuff off from the old SAN drives onto new ones.

Although I have moved the data OLAP onto one of the new SAN LUNs, I still have the Analysis Services configuration file located on an old drive, and I would like to move it.

If it matters, the SQL Server is clustered along with analysis services.

I'm hoping that this can be accomplished without needing to completely re-install it on both cluster nodes.

Any help or advice is greatly appreciated.

Thanks folks!

Post #1422572

SQL Pizza

Posted Friday, February 22, 2013 6:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

- Disconnect all users from the cube
- 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 folde

Greetz
SQL Pizza

sometimes you dont see the pizza for the toppings...
seek and ya shall find...

Post #1423018

Larry Kruse

Posted Friday, February 22, 2013 6:43 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 11:54 AM
Points: 90, Visits: 584

many thanks for the advice Pizza!!!

I will give that a try and ping back here to let you and others know the results. It usually takes me a week to gain approval for a maintenance window on the prod cluster...

Larry

Post #1423026

SQL Pizza

Posted Friday, February 22, 2013 6:47 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

Okay...a pingback would be nice...I know these problems...most of my work is done at night :D!

Greetz
SQL Pizza

sometimes you dont see the pizza for the toppings...
seek and ya shall find...

Post #1423030

Cary Davis

Posted Tuesday, April 30, 2013 1:11 PM

Grasshopper

Group: General Forum Members
Last Login: Today @ 2:16 PM
Points: 17, Visits: 281

I'll shoot something back to you! I actually just moved files to a new volume. I've updated Analysis Server Properties and moved all the files, even updated the Dump Directory in SQL Server Configuration Manager.

Everything works great...until....I try to delete the old olap folder. The msmdsrv.ini file at the old location is still being used by AS when the program starts. If I stop the service and rename this file, AS will not start. So somewhere in the config AS is still holding onto the location of this file which it depends on for start up.

Just don't have any idea where to find it. Any clues?

I definitely can't see the pizza for the toppings here.

Post #1448209

« Prev Topic | Next Topic »

Permissions