Backing up an SSAS database - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Backing up an SSAS database

You can create SSAS database backup files only in the D:\S3 folder on the DB instance. To move the backup files to your S3 bucket, use Amazon S3.

You can back up an SSAS database as follows:

  • A domain user with the admin role for a particular database can use SSMS to back up the database to the D:\S3 folder.

    For more information, see Adding a domain user as a database administrator.

  • You can use the following stored procedure. This stored procedure doesn't support encryption.

    exec msdb.dbo.rds_msbi_task
@task_type='SSAS_BACKUP_DB',
@database_name='myssasdb',
@file_path='D:\S3\ssas_db_backup.abf',
[@ssas_apply_compression=1],
[@ssas_overwrite_file=1];

    The following parameters are required:

    • @task_type – The type of the MSBI task, in this case SSAS_BACKUP_DB.

    • @database_name – The name of the SSAS database that you're backing up.

    • @file_path – The path for the SSAS backup file. The .abf extension is required.

    The following parameters are optional:

    • @ssas_apply_compression – Whether to apply SSAS backup compression. Valid values are 1 (Yes) and 0 (No).

    • @ssas_overwrite_file – Whether to overwrite the SSAS backup file. Valid values are 1 (Yes) and 0 (No).