Saturday, August 27, 2005

Moving cube directories in SQL Server 2005

I ran out of space in my VMware session and had to create a new drive for my AS cubes, this means that i had to move them from their current location to a newly created partition.

This is the process i used, i know you can edit some of this stuff through the GUI , but its far more fun to play with ini files (isn't it)?

All this information applies to the June CTP build, i am guessing it will remain relevant for future builds.

Moving cube directories in SQL server 2005 is fairly easy, all the options for the OLAP component of the software are stored in the installation directory under \MSSQL.2\OLAP\config in a file called msmdsrv.ini

Stop the SQL Server OLAP service.

Before editing anything you should take a copy of this file (store it as msmdsrv.bak) so you can find it later should you need it :)

Underneath the Configuration Settings entry you will see , ensure the service is stopped and then change this value to your new cube directory (remember to save it).
For example my new setting would be e:\as\data

Copy the contents of the old directory which are by default stored in your installation directory under MSSQL.2\OLAP\Data to your new directory and restart the service.

Job Done !!!