SQL Server Performance

Archive Database at Analysis

Discussion in 'Analysis Services/Data Warehousing' started by DBA_Ashfaq, Dec 21, 2006.

  1. DBA_Ashfaq New Member

    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
  2. ranjitjain New Member

  3. satya Moderator

    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.
  4. ranjitjain New Member

    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.
  5. DBA_Ashfaq New Member

    how i can move it give me the steps

    Ashfaq
  6. ranjitjain New Member

    quote:Originally posted by DBA_Ashfaq

    how i can move it give me the steps

    Ashfaq

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

    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.
  8. ranjitjain New Member

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

    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 dba.ashfaq@gmail.com
    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
  10. MohammedU New Member

    This command is not tsql command but you can execute it using xp-cmdshell commaned...

    ex: exec xp-cmdshell 'archive command...'

    Mohammed U.
  11. DBA_Ashfaq New Member



    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

    D:program 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:> “E:program FilesMicrosoft Analysis ServicesBinmsmdarch” /a SERVERNAME “E:program 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
    “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

Share This Page