SQL Server Performance Forum – Threads Archive

Archive Database at Analysis

Hello Everyone….
I am tring to figure out how i can schedule a job which will archive my analysis services database along with all its cube and information. right now when i want it to archieve i open my analysis Manager and then right click on the database and then select Archive database and it archieve it but i want some kind code that make me in position to schedule this process as a single job. any idea please……………. Ashfaq

---

Hi,
Check this KB:
http://support.microsoft.com/kb/294287

---

Ashfaq
Please post your thread in relevant forums only, moved from SQL 2005 DBA section. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

Hi Satya,
You need to move this thread to SQL Server 2000 analysis Services Section,
because the thread is about archieving OLAP DB and this option is only visible in 2000.
In 2005,the same operation is named as backup.
And Ashfaq is saying he can see the option Archieve.

---

how i can move it give me the steps Ashfaq

---

Ashfaq,
Only Moderators can move a thread into any section.

---

Thanks Guys, after I’ve replied about that I did that. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

Hi Satya,
I had suggested to move this thread from as 2005 section to as2000 section because it is related to AS 2000.

---

i tried and look around but didn’t know where i can get the option to move this to SQL 2000.
if you knew you can e-mail me at [email protected]
in regard to you posting
"
Check this KB:
http://support.microsoft.com/kb/294287"
i went through kb article but did not find how i can refrence that command for backup and restore from a query analyzer.
Ashfaq

---

This command is not tsql command but you can execute it using xp-cmdshell commaned… ex: exec xp-cmdshell ‘archive command…’ Mohammed U.

---

I read through articlehttp://support.microsoft.com/kb/312399
To create a batch file and then schedule it to archive analysis cubs.
I tried on my test box Drogram FilesMicrosoft Analysis ServicesBin>msmdarch /a MY_SERVER_NAME “Program FilesMicrosoft Analysis ServicesData” “FoodMart 2000” “C:FoodMart2000.cab” And it really backed/Archived it. But when I try doing it on my production box I used this. U:> “Erogram FilesMicrosoft Analysis ServicesBinmsmdarch” /a SERVERNAME “Erogram FilesMicrosoft Analysis ServicesData” “FoodMart 2000” \ZoolooworgroupsackupMainFoodMart 2000.cab 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
“Erogram FilesMicrosoft Analysis ServicesData” “FoodMart 2000” Where I would be referencing to. If any one has an eagle eye please come forward. Regards Ashfaq

---

]]>