How to Restore an Analysis Services Database Using SQL Server Management Studio
In this article we will take a look at the steps which a database administrator needs to follow to restore an analysis services database. The steps mentioned below are applicable on SQL Server 2005 and higher versions. You can refer the article titled “How to Backup an Analysis Services Database Using SQL Server Management Studio” to know how to restore an analysis services database. Read the following article to know the steps you need to follow to restore a database in SQL Server.
Highly Recommended:- As a DBA your "TOP PRIORITY" should be to make sure your database backups are useful in case of any Disaster and should should know how to recover your database from a Disaster. Learn Different Types of Database Backup Options Supported in SQL Server and How to Fix Database Corruption Issues in SQL Server.
Restore an Analysis Services Database Using SQL Server Management Studio
1. Start SQL Server Management Studio and connect to an analysis services instance. Right Databases Node under Analysis Services Instance and then choose the option Restore…. from the popup menu as shown in the snippet below.
2. In the Restore Database dialog box, there are a number of settings which you have to choose to configure the analysis services database restore.
3. Click the Browse… button to locate analysis services backup file and click OK to save the SSAS Backup file location as shown in the snippet below.
4. In the Restore Database dialog box, the next step will be to specify Restore Target such as Restore Database Name and Storage Location.
5. The Restore Storage Location can be specified by click the Browse… button in the Restore Database Dialog Box next to Storage Location. This will open up Browse for Remote Folder dialog box as shown in the snippet below. In Browse for Remote Folder dialog box, you need to specify the location where you would like to save the analysis services database. Once the SSAS database restoration path is specified click OK to save the changes and to return to the parent Restore Database Dialog Box.
Continue Free Learning...
Click on Next Page to continue reading rest of the article…