How to backup all SSAS databases ?

Question

How to backup all SSAS databases ?

awu

SSCrazy

Points: 2037
More actions
December 16, 2011 at 5:13 pm

#253668

We can easily backup one SSAS database by using the management studio , but how to create a job to backup all SSAS databases ? Thanks.
ddfg

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

Per BOL:

There are many ways to back up your Microsoft SQL Server Analysis Services databases and they all require that you have server administrator and database administrator permissions. You can open the Backup dialog box in SQL Server Management Studio, select the appropriate options configuration, and then run the backup from the dialog box itself. Or, you can create a script using the settings already specified in the file; the script can then be saved and run as frequently as required.

For More: http://msdn.microsoft.com/en-us/library/ms186830.aspx

salum SSCommitted Points: 1598 More actions · Answer 2

awu (12/16/2011)
We can easily backup one SSAS database by using the management studio , but how to create a job to backup all SSAS databases ? Thanks.

Here is very nice article for you..which can help you take backup of ALL SSAS database

http://www.sqlservercentral.com/articles/Analysis+Services+(SSAS)/63382/

java[/url]

Arjun SreeVastsva SSCertifiable Points: 7141 More actions · Answer 3

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.

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.

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

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.

STEP 5 - Backup is in progress, depends upon the size of the 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).

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