Post reply

2005 SSAS Cube availability during processing

  • October 15, 2009 at 12:30 am

    #136686

    I have worked mainly on Analysis Services 2000 and so accept downtime of the cubes while processing. From my research into SSAS (2005) I believe that SSAS creates a copy of the cube and dimensions when processing and only overwrites them at the end of processing?

    I have the possibilty of one SSAS server to build the cubes and one SSAS server to be used when users query the cubes. Whats the best way to achieve high availabilty? Is it possible to get it down to no downtime?

    Thanks.

    Ells

    😎

  • October 21, 2009 at 4:47 am

    #1068754

    As there has been no responese -

    has anyone set theor system up to synchronise after processing on a staging server?

    This is currently my best option as I do have a staging server available.

    Cheers.

    Ells

    😎

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply