Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
You can back up your Microsoft SQL Server SQL Server Analysis Services databases in many ways. All methods require server administrator and database administrator permissions. You can open the Backup dialog box in SQL Server Management Studio, select the appropriate options, and then run the backup from the dialog box. Or, you can create a script using the settings already specified in the file. You can save and run the script as frequently as required.
Backup and synchronize
If the database is on a remote instance of SQL Server Analysis Services, you can use the synchronization feature to back up the database to the local instance. You can move development builds of a database into production by using this feature. You can also use conventional, file-based, backup and restore to move the development build into production. However, synchronization provides extra functionality. For example, you can have security settings that are different for the development and production computers. Synchronization gives you the option to maintain those settings and synchronize all objects other than roles. Also, synchronization typically does an incremental update of those objects that are different for the source and destination computers. This kind of incremental backup isn't available by using the backup/restore feature. For more information, see Synchronize Analysis Services Databases.
Important
The Analysis Services service account must have permission to write to the backup location that you specify for each file. Also, you must have one of the following roles: administrator role on the SQL Server Analysis Services instance, or a member of a database role with Full Control (Administrator) permissions on the database to back up.
See also
Backup Database Dialog Box (Analysis Services - Multidimensional Data)
Backup and Restore of Analysis Services Databases
Backup Element (XMLA)
Backing Up, Restoring, and Synchronizing Databases (XMLA)