We are running Analysis Services in SQL Server 2000 Enterprise SP4 on a Windows 2000 Advanced Server SP4.
We have a job which runs overnight and backs up our live cube. this backup is then restored to a second server for failover (using msmdarch, as described in http://support.microsoft.com/kb/312399
recently, when we tried to fail over, we discovered that the backup cube has a status of "not processed", so no longer works for failover. The backup cube used to be queryable as soon as it had been restored by msmdarch. the only difference we can think of is that Analysis Services has been service Pack'd since then (now on SP4).
Has anyone else seen this problem? do you have a fix/workaround?
Is there some way to get msmdarch utility to function so that the cube is restored already processed?
it has been suggested that we simply add a step to our job to reporocess the cube; this is not really possible as the cube reprocessing takes around 2 hours, and uses a lot of server resources; the server is already busy all night, in fact we are currently trying to trim the overnight schedule so that processing finishes earlier, as currenlty sometimes it takes so long that it runs into business hours.