December 16, 2011 at 5:13 pm
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
December 17, 2011 at 2:52 am
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
December 18, 2011 at 6:00 am
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://qa.sqlservercentral.com/articles/Analysis+Services+(SSAS)/63382/
December 22, 2011 at 6:26 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply