Analysis Services 数据库备份和还原Analysis Services database backup and restore

在 Azure Analysis Services 中备份表格模型数据库与在本地 Analysis Services 中备份大致相同。Backing up tabular model databases in Azure Analysis Services is much the same as for on-premises Analysis Services. 主要区别在于存储备份文件的位置。The primary difference is where you store your backup files. 必须将备份文件保存到 Azure 存储帐户的容器中。Backup files must be saved to a container in an Azure storage account. 可以使用已有存储帐户和容器,也可以在为服务器配置存储设置时创建。You can use a storage account and container you already have, or they can be created when configuring storage settings for your server.


创建存储帐户可能会导致新的计费服务。Creating a storage account can result in a new billable service. 若要了解详细信息,请参阅 Azure 存储定价To learn more, see Azure Storage Pricing.


如果存储帐户位于另一区域中,请将存储帐户防火墙设置配置为允许从“所选网络” 进行访问。If the storage account is in a different region, configure storage account firewall settings to allow access from Selected networks . 在防火墙的“地址范围” 中,指定 Analysis Services 服务器所在区域的 IP 地址范围。In Firewall Address range , specify the IP address range for the region the Analysis Services server is in. 支持将存储帐户防火墙设置配置为允许从“所有网络”进行访问,但是最好选择“所选网络”并指定 IP 地址范围。Configuring storage account firewall settings to allow access from All networks is supported, however choosing Selected networks and specifying an IP address range is preferred. 若要了解详细信息,请参阅网络连接常见问题解答To learn more, see Network connectivity FAQ.

备份以 .abf 扩展名保存。Backups are saved with an .abf extension. 对于内存中表格模型,将存储模型数据和元数据。For in-memory tabular models, both model data and metadata are stored. 对于 DirectQuery 表格模型,将仅存储模型元数据。For DirectQuery tabular models, only model metadata is stored. 备份可以进行压缩和加密,具体取决于选择的选项。Backups can be compressed and encrypted, depending on the options you choose.

配置存储设置Configure storage settings

备份前,需要为服务器配置存储设置。Before backing up, you need to configure storage settings for your server.

配置存储设置To configure storage settings

  1. 在 Azure 门户中,转到“设置” ,单击“备份” 。In Azure portal > Settings , click Backup .


  2. 单击“已启用” ,并单击“存储设置” 。Click Enabled , then click Storage Settings .


  3. 选择存储帐户,或新建一个。Select your storage account or create a new one.

  4. 选择容器,或新建一个。Select a container or create a new one.


  5. 保存备份设置。Save your backup settings.



使用 SSMS 备份To backup by using SSMS

  1. 在 SSMS 中,右键单击某个数据库,转到“备份” 。In SSMS, right-click a database > Back Up .

  2. 在“备份数据库” > “备份文件” 中,单击“浏览” 。In Backup Database > Backup file , click Browse .

  3. 在“文件另存为” 对话框中,验证文件夹路径,并键入备份文件的名称。In the Save file as dialog, verify the folder path, and then type a name for the backup file.

  4. 在“备份数据库” 对话框中,选择选项。In the Backup Database dialog, select options.

    “允许覆盖文件” - 选择此选项可覆盖具有相同名称的备份文件。Allow file overwrite - Select this option to overwrite backup files of the same name. 如果未选择此选项,则要保存的文件不能与同一位置中已存在的文件具有相同的名称。If this option is not selected, the file you are saving cannot have the same name as a file that already exists in the same location.

    “应用压缩” - 选择此选项可压缩备份文件。Apply compression - Select this option to compress the backup file. 压缩的备份文件可节省磁盘空间,但需要稍高的 CPU 使用率。Compressed backup files save disk space, but require slightly higher CPU utilization.

    “加密备份文件” - 选择此选项可加密备份文件。Encrypt backup file - Select this option to encrypt the backup file. 此选项要求用户提供密码来保护备份文件。This option requires a user-supplied password to secure the backup file. 密码可防止采用还原操作外的任何其他方式读取备份数据。The password prevents reading of the backup data any other means than a restore operation. 如果选择对备份加密,请将密码存储在安全位置。If you choose to encrypt backups, store the password in a safe location.

  5. 单击“确定” 创建并保存备份文件。Click OK to create and save the backup file.


使用 Backup-ASDatabase cmdlet。Use Backup-ASDatabase cmdlet.


还原时,备份文件必须在已为服务器配置的存储帐户中。When restoring, your backup file must be in the storage account you've configured for your server. 如果需要将备份文件从本地位置移到存储帐户,请使用 Azure 存储资源管理器AzCopy 命令行实用工具。If you need to move a backup file from an on-premises location to your storage account, use Azure Storage Explorer or the AzCopy command-line utility.


如果要从本地服务器还原,必须先从该模型的角色中删除所有域用户,并再将这些用户作为 Azure Active Directory 用户重新添加到这些角色。If you're restoring from an on-premises server, you must remove all the domain users from the model's roles and add them back to the roles as Azure Active Directory users.

使用 SSMS 还原To restore by using SSMS

  1. 在 SSMS 中,右键单击某个数据库,转到“还原” 。In SSMS, right-click a database > Restore .

  2. 在“备份文件” 的“备份数据库” 对话框中,单击“浏览” 。In the Backup Database dialog, in Backup file , click Browse .

  3. 在“定位数据库文件” 对话框中,选择要还原的文件。In the Locate Database Files dialog, select the file you want to restore.

  4. 在“还原数据库” ,选择数据库。In Restore database , select the database.

  5. 指定选项。Specify options. 安全选项必须与备份时使用的备份选项相匹配。Security options must match the backup options you used when backing up.


使用 Restore-ASDatabase cmdlet.Use Restore-ASDatabase cmdlet.

Azure 存储帐户Azure storage accounts
高可用性 High availability
Analysis Services 网络连接常见问题解答Analysis Services network connectivity FAQ