Trending SQL Server Tips

How to Restore an Analysis Services Database Using SQL Server Management Studio

By: Editor
March 16, 2010

Page: 1/2

Introduction

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.

Restore Analysis Services 2008 Database

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.

Restore Analysis Services Database Using SQL Server Management Studio


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.

Locate Analysis Services Database File for Restore

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.

In Browse for Remote Folder dialog box, you need to specify the location where you would like to save the analysis services database  

Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article



Click on Next Page to continue reading rest of the article…


Next Page..



Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."