| title | description | ms.date | ms.service | ms.custom | ms.topic | ms.author | ms.reviewer | author |
|---|---|---|---|---|---|---|---|---|
Analysis Services Restore Options | Microsoft Docs |
Learn about ways to restore your Microsoft SQL Server Analysis Services databases, and how to automate the restore process with XMLA. |
05/02/2018 |
analysis-services |
multidimensional-models |
conceptual |
kfollis |
kfollis |
kfollis |
[!INCLUDEappliesto-sqlas] There are many ways to restore your [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] databases, all of which require that you have administrator permissions for both the server computer and the [!INCLUDEssASnoversion] database. To restore an [!INCLUDEssASnoversion] database, you can open the Restore Database dialog box in [!INCLUDEssManStudioFull], 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).
Important
For each backup file, the user who runs the restore command must have permission to read from the backup location specified for each file. To restore an [!INCLUDEssASnoversion] database that is not installed on the server, the user must also be a member of the server role for that [!INCLUDEssASnoversion] instance. To overwrite an [!INCLUDEssASnoversion] database, the user must have one of the following roles: a member of the server role for the [!INCLUDEssASnoversion] instance, or a member of a database role with Full Control (Administrator) permissions on the database to be restored.
Note
After restoring an existing database, the user who restored the database might lose access to the restored database. This loss of access can occur if, at the time that the backup was performed, the user was not a member of the server role or was not a member of the database role with Full Control (Administrator) permissions.
Restore Database Dialog Box (Analysis Services - Multidimensional Data)
Backup and Restore of Analysis Services Databases
Restore Element (XMLA)
Backing Up, Restoring, and Synchronizing Databases (XMLA)