• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 578
  • Last Modified:

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.
0
the_crazed
Asked:
the_crazed
  • 4
  • 4
1 Solution
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now