Backup Database Dialog Box (SSAS)

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. You can display the Backup Database dialog box by right-clicking a database in Object Explorer and selecting Back Up from the context menu.

Options

Term

Definition

Database

Displays the name of the currently selected Analysis Services database.

Backup file

Type the full path and file name of the backup file to use.

Browse

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 (SSAS).

Allow file overwrite

Select to overwrite an existing backup file or remote backup file, if one exists.

ms186830.note(en-US,SQL.90).gifNote:

If this option is not selected and the backup file specified in Backup file or a remote backup file specified in Remote backup file exists, an error occurs.

Apply compression

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.

Password

Type the password to use when encrypting the backup file and, if specified, remote backup files.

ms186830.note(en-US,SQL.90).gifNote:

This option is enabled only if Encrypt backup file is selected.

Confirm Password

Type the password entered in Password to confirm the password for the backup file and, if specified, remote backup files.

ms186830.note(en-US,SQL.90).gifNote:

This option is enabled only if Encrypt backup file is selected.

Backup remote partition(s)

Select to include location information and data for remote partitions in the backup file.

ms186830.note(en-US,SQL.90).gifNote:

This option is enabled only if the currently selected Analysis Services database uses remote partitions.

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:

Column

Description

ServerDisplays the Analysis Services instance that manages the remote partitions.

DatabaseDisplays the Analysis Services database that contains the remote partitions.

Partition ListDisplays the list of remote partitions contained by the database displayed in Database.

Remote backup fileType 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 (SSAS).

See Also

Reference

Analysis Services Designers and Dialog Boxes (SSAS)

Other Resources

Backing Up and Restoring an Analysis Services Database

Help and Information

Getting SQL Server 2005 Assistance