Cube "Not Processed" when restored using msmdarch

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.
LVL 8
the_crazedAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PFrogCommented:
Are both servers running identical versions of SQL Server?
I've seen restoration problems before when the servers had different service packs of SQL.
0
the_crazedAuthor Commented:
great thought! but no dice.
the versions are slightly different (source is Enterprise and destiation is reqular sql 2000), but we have built a Proof of Concept using two Sql Enterprise Installations, and the result is identical, sorry.
0
PFrogCommented:
Sorry about the delay - been on holiday...

Do you get the same problem when you backup/restore manually through Management Studio?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

the_crazedAuthor Commented:
no probs, hope your holiday was nice!

and no, when we do it manually the cube works; it's restored with "Processed" status; the problem only occurs when using msmdarch.

trouble is that we need it to run automatically overnight, we can't waste our DBA's time having him manually restore the cube every morning.

thanks for sticking with this, PFrog.
0
PFrogCommented:
Just noticed you're using SQL 2000 - please ignore last post!

Unfortunately I haven't got a 2000 box to play with, so I can't even try to replicate your problem - sorry...
0
the_crazedAuthor Commented:
oh well. I guess the fact that we're on outdated technology is the reason I'm not getting much response on this from EE.
thanks anyway!
0
the_crazedAuthor Commented:
right, we solved this our selves in the end.

turned out it was DBA error. To handle free space problems he'd moved the cube storage to a different drive, and repointed the cube. However, he'd not altered the setting in the msmdarch job

there you go
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PFrogCommented:
Thanks for the update post - that's a useful one to know for the future.
0
modus_operandiCommented:
Closed, 500 points refunded.
modus_operandi
EE Moderator
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.