How to restore an Analysis Services Database

Problem
One of the Junior DBA in my company approached me yesterday with a dilemma. He was assigned a task to restore an Analysis Service SQL Server 2008 Database on a development server. At first I started to tell him, but figured it would be smarter to document the steps which he needs to perform to successfully restore an analysis service database from an encrypted analysis service database backup on an SQL Server 2008 Analysis Services Instance.

Solution
In this tip, you will go through the steps which a DBA needs to perform to successfully restore an analysis service database to a SQL Server 2008 Analysis Service Instance.  I will show you how this can be done via SSMS and also using an XMLA query.

Read more...