October 22, 2007 at 3:08 pm
Hi,
I have several SQL2005 Analysis cubes that are currently located on the C drive. The drive is filling up and I need to move them to the D drive. I tried to search via books online, etc. on how to do so but as of now do not have a clear method of doing so.
Can you provide me the best way as to move the cubes to another drive?
regards,
Steve B
October 23, 2007 at 9:11 pm
Moved to Analysis Services forum. Please watch the forum names.
October 23, 2007 at 9:20 pm
First, change the location As2005 is using for its data directory. Connect to the server using Management Studio, goto the server properties (right click on the server name). You should see a property called "DataDir". It will most likely be pointing at the installation folder on drive c: (something like C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data)
Create an appropriate folder on the drive you want to use and change the value in "DataDir" to name of this folder.
Restart Analysis Services.
Using Management Studio
- Backup you cubes
- Delete them
- Restore them
You should find that they are now on the "new" partition.
November 2, 2007 at 10:46 am
Is there any way to specify different directories for different MS AS databases on the same server? This option seems to be at the server level (assuming only one instance of MS AS on the server). This seems kind of odd given that you can specify different directories for SQL databases.
November 2, 2007 at 10:28 pm
You can't easily select a different folder for each database. Yeah, it would be nice to have more flexibility especially when it comes to storing partitions on different drives to enhance performance. Perhaps you could request this feature (via the connect web site)
December 29, 2007 at 7:25 pm
Thanks for this tip happycat59. I needed to do this same procedure and your advice was spot on!
Cheers - scottie:)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply