moving SSAS 2005 database to another drive

Question

 

Hello,

 

how can I move the SSAS 2005 database to another drive ? The reason is, I´m running out of space on the current drive.

Thanks a lot for an answer.

Answer 1

Hi,

You can change the Data folder for AS2005, to move all the databases to another location (you cannot have separate locations for databases on the same AS2005 instance). To do that:

1. use the server's properties dialog to specify the new path (from SQL Management Studio, connect to AS2005, right click on the server, Properties, DataDir property) (the change will not become effective immediately, no actual data will be moved)

2. stop AS2005

3. move the Data directory to the drive you want

4. restart AS2005