Restore Database Dialog Box (Analysis Services - Multidimensional Data)

Use the Restore Database dialog box in SQL Server Management Studio to restore an Analysis Services database from a backup file using the Analysis Services Backup File (.abf) format.

Security note Security Note

For each backup file, the user who runs the restore command must have permission to read from the backup location specified for each file. To restore an Analysis Services database that is not installed on the server, the user must also be a member of the server role for that Analysis Services instance. To overwrite an Analysis Services database, the user must have one of the following roles: a member of the server role for the Analysis Services instance, or a member of a database role with Full Control (Administrator) permissions on the database to be restored.

Note

After restoring an existing database, the user who restored the database might lose access to the restored database. This loss of access can occur if, at the time that the backup was performed, the user was not a member of the server role or was not a member of the database role with Full Control (Administrator) permissions.

To display the Restore 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 Restore.

The Restore Database dialog box contains the following pages.

Pages

See Also

Reference

Analysis Services Designers and Dialog Boxes (Multidimensional Data)

Concepts

Backup and Restore of Analysis Services Databases