Backing Up an Analysis Services Database

Leave a comment (0) Go to comments

How to Backup Analysis Services Database ?

Backing up Analysis Services database, lets administrators save a particular state of a SQL Server Analysis
Services database and its objects.

We can take Analysis Services Database Backup in various ways

  1. Manually, graphically using SQL Server Management Studio
  2. Manually, using a XMLA command / script
  3. Schedule a Analysis services backup as SQL Server scheduled Job.

Here we are learning option One, Manually, graphically using SQL Server Management Studio

STEP By STEP procedure for backing up Analysis Services Database.

STEP 1 - Connect to Analysis Services Instance on which you want to take backup.

Backing Up an Analysis Services Database

STEP 2 - Once you are connected to Analysis Services in SSMS, in Object Explorer, right-click the
OLAP database (DBATAG in my case), and then click Back Up.


Backing Up an Analysis Services Database

STEP 3 - In Backup Window, General page, Choose Browse Option to specify the backup location path

Backing Up an Analysis Services Database

STEP 4 - In Save File As Box, specify the location, where you want to create a backup file. Once specified, Click OK. Ensure that file directory exists and you have write permissions in that directory.

Backing Up an Analysis Services Database

STEP 5 - Backup is in progress, depends upon the size of the database.

Backing Up an Analysis Services Database

STEP 6 - Once the backup is complete, you can verity the backup file in specified folder, you can see a file with extension .abf (Analysis backup file).

Backing Up an Analysis Services Database

Note : there is no option available for verification like relation engine services.

EOF - Backing Up an Analysis Services Database, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.