HI,
i am trying to backup the olap database from a script i wrote but the sql
server is raising a error

'msmdarch' is not recognized as an internal or external command,
operable program or batch file.
NULL
and if i execute the script from dos(msmdarch) it works fine
do any body know how to remove this error .
thanx

--
waiting for solution
from
Sufian

You are probably missing a path to msmdarch.exe.

Edward Melomed
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Mohd Sufian" <sufian (AT) aeroflex (DOT) co.th> wrote

Hi Edwars,
I am passing the right path as
c:\program files\Microsoft Analaysis Services\bin\msmdarch /A
and i had checked it but when i run the script from cmd shell it runs fine
but as i run the script it generates the error as i mentioned in the
questation.

if u had better way pls let me know.
thanx for u r reply
--
waiting for solution
from
Sufian


"Edward Melomed [MSFT]" wrote:

I am confused. When you say "as I run the script", what do you mean? Can you
attach a sample script which fails and how you are invoking it. My guess is
that the problem may be how you are invoking the script; not the script
itself (since you say that the script runs OK in a cmd shell).
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Mohd Sufian" <sufian (AT) aeroflex (DOT) co.th> wrote

Hi Dave,
I dont understand why r u confused becasue if u run the msmdarch utility
giving server name database name and log file path name it will archive the
AS databse.
Below is the procedure written to BAckup the AS Database archiving.


CREATE PROCEDURE [dbo].[ms_olapbackup] AS
declare
@command varchar(550)
set @command=('msmdarch / A'+ 'epi-it-sufian' + 'c:\program files\microsoft
analysis services\data'+'olap_aicnav_data'+'c:\olap_aicnav_ data.cab')

EXEC master..xp_cmdshell @command
GO
the path of msmdarch exe is" c:\program files \microsoft analysis
services\bin"
Thanx to help me
but waiting for the reply
--
waiting for solution
from
Sufian


"Mohd Sufian" wrote: