dbTalk Databases Forums  

Relocate Partition Data

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Relocate Partition Data in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kyle Henly
 
Posts: n/a

Default Relocate Partition Data - 10-05-2006 , 09:54 AM






Hi,

I'm trying to move a bunch of partitions on to a new disk in my dev
environment. I've modified the properties of the partition so that the
storage location is now set to where i would like the partition stored.

I would guess all that needs to occur physically is the underlying files of
that partition need to be moved to this new location. But how/when is that
done by SSAS?

What level of processing to i need to do to get my partition data to it's
new location - if i need to process at all? All i'm trying to achieve is the
movement of the existing partition data.

I did originally try to restore the database and move the storage like that.
However, SSAS forces you to use the default location for data if that is
what you originally had set for ALL your partitions. Not good!

Hope you can help...

Thanks.
--
Kyle Henly
DBA
U.K.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.