Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    29

    Unanswered: How to use XMLA to restore multiple cubes at a time?

    In SSMS, I have set up a job step using "SQL Server Analysis Services Command" with <Restore> element to restore 1 cube.
    <Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
    <File>...</File>
    <DatabaseName>...</DatabaseName>
    </Restore>

    I'm able to restore 1 cube at a time. But how can I use the same job step to restore multiple cubes?

    Or is there any way I can loop through the directory where I save all .abf files and then restore each .abf?

    Thanks!!

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    you could use ascmd.exe to do this - it's like sqlcmd but for running DMX/XMLA scripts.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •