Restore the Analysis Services databases from the discovered analysis services instance. You can either restore the databases to their original location on the same computer or you can select a different destination server to restore them. You can choose different combinations of restore options to perform different types of restores.
Before You Begin
You must have a backup copy of the Analysis Services databases. For more information on backing up Analysis Services databases, see Backing Up SQL Databases.
Note
Specify a backup staging directory for the destination SQL instance, else restores to the instance might fail.
Procedure
-
From the CommCell Browser, click Client Computers > client > SQL Server.
-
Right-click the Analysis Services instance, and then click All Tasks > Browse and Restore.
-
In the Browse and Restore Options dialog box, click View Content.
-
Select the Analysis Services databases that you want to restore, and click Recover All Selected.
The SQL Restore Options dialog box is displayed.
-
On the General tab, choose how you want to restore the data.
For more information about general restore options, see SQL Restore Options (General).
-
On the Job Initiation tab, choose whether to run the restore job immediately or on a schedule.
-
Optional: Run your restore operations from a command line interface. Click Save as Script.
For more information, see Command Line Interface.
-
Click OK.
If you selected to run the restore job immediately, you can monitor the progress of your restore job in the Job Controller window. For more information, see Job Controller.
After the restore job is complete, you can view the restore job history. For more information, see Job History.