Export (0) Print
Expand All

Restore Options

There are many ways to restore your Microsoft SQL Server 2005 Analysis Services (SSAS) databases, all of which require that you have administrator permissions for both the server computer and the Analysis Services database. To restore an Analysis Services database, you can open the Restore Database dialog box in SQL Server Management Studio, select the appropriate options configuration and then run the restore from the dialog box. Or, you can create a script using the settings already specified in the file; the script can then be saved and run as often as needed. In this way, the restore is completed by using XMLA, as described in the next section.

The XMLA Restore command is a way to automate the restore process by running a restore based on an .abf file. The Restore command has a number of properties that can be set to specify security definitions, where remote partitions should be stored, and the relocation of relational OLAP (ROLAP) objects. For more information, see Restore Element (XMLA).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft