Moving SSAS Database to a new drive on same server

Question

Hello,

I am running out space on the drive that houses our SSAS databases (currently there are three). When I process the biggest cube, I get the LazyWriter error complaining that there is not enough space. I want to move just this database to a new drive on the same server.

I followed the instructions for moving a database through SSMS (attach/detach DB) outlined in the link below:

http://msdn.microsoft.com/en-us/library/cc280670.aspx

Everything completed smoothly and the cube process (through SSMS) completed successfully. There is a maintenance guy who is in charge of routine data refreshes and he recently processed the cube through Visual Studio and got the running out of space error. I checked and it looks like the database is again being stored on the first drive.

Is there some step I am missing on moving a SSAS database? Is there a setting in Visual Studio that I am not aware of?

Thanks,

Wonil

Answer 1

Do you have a SSAS 2005 or 2008?

Answer 2

Sorry, I should have clarified that in my original post. We are running 2008.

Answer 3

Hi

in visual studio (project) you define where the deployment of the database has to be done. In the solution explorer right-click the database choose properties and then select the deployment tab. Modify to fit your needs.

Regards
Stefan

Answer 4

Hi Stefan,

Thanks for taking the time to reply.

I have seen that tab but the options only allow you to specify the target server. In my case the target server is going to remain the same. I just need the file directory where the database is stored to change.

Thanks,

Wonil

Answer 5

Hi Wonil,
connect in management studio to analysis services. Right click instance name, choose properties. Change DataDir property, restart and deploy.

Jiri

Answer 6

Hi Jiri,

Thanks for your reply. 

Doesn't that move files for all the cubes on the server to the new directory? I would just like to move the biggest cube to the new drive.

I do see a Storage Location property when you view the properties for a specific database. But I can't seem to enter a value for this property.

Thanks again!

Wonil

Answer 7

Hi Wonil,
If you want to move just one cube, browse database, than find your cube and right click that cube, there is a storage location property in general category of properties and you can change it there.

Hope it helps

Jiri

Answer 8

Hi Jiri,

What will happen with other cubes if i change storage location property?

Will i need to redeploy all of them?

Note: i'm talking about SSAS 2005

Thanks