Restoring an SSAS Database (CUBE).

If you need to restore a database, you will need to be a server administrator.

Additionally, if the backup file was created with a password, you’ll need to provide that password to successfully restore the file.

Right-click the Databases folder (SSAS tree), and then click Restore.

Your screen looks like below

·         You have the option to restore the database using a different name. If the database already exists on the server, you need to explicitly select the option to Allow Database Overwrite. Also, you can choose whether to keep or discard security information associated with the database.

·         In the Restore Database box, type 'Restored Database' a SSAS Database name to restore backup file.

·         Back file having the extension as abf please select backup file on clicking on Browse button as disply in above diagram.

·         Click the Browse button and expand the C:\Program Files\Microsoft SQL Server \MSSQL.2\OLAP\Backup folder, select Backupfile.abf click ok or Put location of backup file stored.

·         In the Password box, type the password that you used when you archived the database in the previous procedure, and then click OK if not then no need to write down.

·         In After success full restored go to object Explorer, right-click the Databases folder for the Analysis server, and click  Refresh you will get the 'Restored Database' that we restored in SSAS Database.

Posted by - SUHAS R. KUDEKAR (MCTS - Microsoft Business Intelligence)

Learning Office 2010 + SharePoint 2010 + SQL Server 2008 R2