Need to move an AS cube partition without unprocessing it - by Dave Mariani

Status : 


Sign in
to vote
ID 627110 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 12/2/2010 10:24:00 AM
Access Restriction Public


SSAS 2008 R2 allows users to change the Storage Location for a cube partitions in BIDS.  However, when doing so on an already processed partition, SSAS will unprocess the partition.  For large scale data sets, this is not a viable option.

We need the ability to move a partition to a different storage location without unprocessing the data.  In order to accomplish this goal today, we have to use the following hack:

1. Stop the SSAS Service
2. Copy the *.prt partition directory and its contents from the source default location to the new target volume directory
3. Make a backup copy of the *.prt.xml file for the affected partition in the source default partition parent directory
4. Change the <StorageLocation> option in the *.prt.xml in the source default partition parent directory to the new target volume parent directory 
5. Restart the SSAS Service so that SSAS will create a new GUID style subdirectory under the new target volume’s parent directory
6.  Expand the Partitions so that SSAS will create a new GUID style subdirectory under the new target volume’s parent directory
7. Stop the SSAS Service
8. Move the files from the new partition volume parent directory into the new target volume’s GUID subdirectory
9. (Optionally) Delete all files EXCEPT the info*.xml file from the source default partition location (and leave the directory intact)
10. Copy the info*.xml file back to the source partition directory
11. Start the SSAS Service

Obviously, this is not a good long term solution.
Sign in to post a comment.
Posted by David Bond on 5/1/2013 at 8:08 AM
We have a workaround:

Create a new partition in the Measuregroup with the StorageLocation set to the desired new location
Ensure the source for the new partition returns no rows, e.g. a QueryBinding with 1=0 after the WHERE
ProcessFull the new partition so that it is now a valid target for a merge
MERGE the "partition(s) to move" with the newly-created partition as the target
Posted by David Bond on 5/1/2013 at 7:48 AM
We too REALLY need this feature. Our plan is to process partitions on SSD until there is no more data to add into them, then MOVE them onto HDD for query-only IO.

Any workarounds welcome, but SSAS restart is not acceptable.
Posted by Sinhas on 11/7/2012 at 11:36 AM

We have to move processed partition to another storage location as our data cube is expected to grow bigger and we are already facing space issues. While searching online for the method to move partitions, I came across this site. I was wondering if we have a fix out there for this bug or we have to follow the work around that is mentioned here so that by moving processed partitions to a new storage location they remain in a processed state.

Any help on this is highly appreciated.


Sinha S

Posted by Microsoft on 2/2/2011 at 8:15 PM
Thanks for opening this issue, Dave. We will consider it for a future version of Analysis Services.