msmdarch command hangs and requires restart of MSSQLServerOLAPService -
04-06-2004
, 02:35 PM
I am running a daily cube backup of an Analysis Services 2000 SP3
database on an NT 4.0 machine. I am using the following command line
for msmdarch in a job on the server:
"d:\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a
servername "d:\Program Files\Microsoft Analysis Services\Data\"
"dbname" "f:\OLAP backups\ODSMart.cab"
This works like a charm on 4 of our servers where we have multiple
cubes with the same hardware and software setup. One of the servers
however seems to "hang up" on this step once every 2 months or so.
You can kill the job to stop the process but in order to get it or
data retrieval from the cube to work after that point you must stop
and restart MSSQLServerOLAPService. The cube database that is being
backed up is only about 350MB and disk space is not an issue on any of
the 3 hard drives. A successful archive takes about 25 minutes. Any
ideas? Is this a known issue that I have missed? Thanks in advance.
Stephen |