Backup Database Dialog Box (Analysis Services - Multidimensional Data)
Applies To: SQL Server 2016
Use the Backup Database dialog box in SQL Server Management Studio to back up an Analysis Services database to a backup file using the Analysis Services Backup File (.abf) format.
To display the Backup Database dialog box
- In SQL Server Management Studio, right-click either the Databases folder of an Analysis Services instance or a database in Object Explorer, and then click Backup.
Creates a backup script that is based on the options selected in the dialog box. The restore script is written in the Analysis Services Scripting Language (ASSL).
Clicking the Script icon sends the backup script into a new query window, by default.
Clicking the Script arrow displays a menu that allows you to choose where to send the backup script:
To a new query window (default).
To a file.
To the clipboard.
To a job.
Displays the name of the currently selected Analysis Services database.
Type the full path and file name of the backup file to use.
Click to display the Save File As dialog box and select the path and file name of the backup file to use. For more information about the Save File As dialog box, see Save File As Dialog Box (Analysis Services - Multidimensional Data).
Allow file overwrite
Select to overwrite an existing backup file or remote backup file, if one exists.
Select to compress the contents of the backup file and, if specified, remote backup files.
Encrypt backup file
Select to encrypt the backup file using the password supplied in Password.
Type the password to use when encrypting the backup file and, if specified, remote backup files.
Type the password entered in Password to confirm the password for the backup file and, if specified, remote backup files.
Backup remote partition(s)
Select to include location information and data for remote partitions in the backup file.
Remote partition backup location
Displays the location of remote partitions associated with the selected database, as well as the remote backup file used to back up the data and metadata for the remote partitions. The following columns are available:
|Server||Displays the Analysis Services instance that manages the remote partitions.|
|Database||Displays the Analysis Services database that contains the remote partitions.|
|Partition List||Displays the list of remote partitions contained by the database displayed in Database.|
|Remote backup file||Type the full path and file name of the remote backup file to use, or click the ellipsis button (...) to display the Save File As dialog box and select the path and file name of the remote backup file to use. For more information about the Save File As dialog box, see Save File As Dialog Box (Analysis Services - Multidimensional Data).|