Dear Vidas, I hope you can point me i
Dear Vidas,
I hope you can point me in the right direction with your experience. We have a large (100G) cube that I process on server A then synchronize to server B. Because the daily changes are huge, the synchronization takes around 30 minutes if using your SSIS package to process some partitions and all dimensions or 2 hours if the cube is fully reprocessed. We have recently acquired a promizing application called NetApp which allows very rapid cloning of drives/files/folders etc so that cloning the data folder for the cube (located in C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data folder) from server A to server B takes less than a minute (compared to 2 hours when using Synchronize). The idea is to clone the data folder from server A (C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data location) to server B (same location). I assume I will need to clone the assotiated .db file as well which is no problem. But how do I make the SSAS server on server B "see" the cloned cube? The Synchronize command does the copying and it "mounts" the cube as well. I was wondering if there is a script to mount the data folder files from a server A (and copied to the server B) to the SSAS server on server B. Thanks!