Cube Backup Job | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Cube Backup Job

Hello every one. I read through article
To create a batch file and then schedule it to archive analysis cubs.
I tried on my test box D:program FilesMicrosoft Analysis ServicesBin>msmdarch /a MY_SERVER_NAME “Program FilesMicrosoft Analysis ServicesData” “FoodMart 2000” “” And it really backed/Archived it. But when I try doing it on my production box I used this. U:> “E:program FilesMicrosoft Analysis ServicesBinmsmdarch” /a SERVERNAME “E:program FilesMicrosoft Analysis ServicesData” “FoodMart 2000” \ZoolooworgroupsackupMainFoodMart I don#%92t know what I am missing even though I see that msmdarch.exe is started but after few seconds disappear on task manager window. Also my actual cube data I am linking from a local sql server so instead of referring to
“E:program FilesMicrosoft Analysis ServicesData” “FoodMart 2000” Where I would be referencing to. If any one has an eagle eye please come forward. Regards Ashfaq
Canyou check for any information in Event viewer or error log for this behaviour.
Try to run MSMDARCH without any parameters for more information. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
You need to check that the service account running Analysis Services has write permission ot the share \ZoolooworgroupsackupMain that you’re backing up to. It may be a permissions problem. Try running msmdarch to back up to a file on a local drive and see if it works.