Backup using SSMS:
1. Login to SSAS instance using SSMS
2. Right-Click on the Analysis service database you want to backup.
3. And Choose the option Backup.
4. Now in the Backup Database page, Enter the location to where you want the backup file to be placed.
5. Choose the other options, if required.
6. And Click on OK to backup the database.
Backup Using XMLA Query Editor:
1. Open the XMLA Query Editor using the New Query Option.
2. Enter the below query.
<Backup xmlns="http://schemas.
<Object>
<DatabaseID>Test</DatabaseID>
</Object>
<File>E:\Test.abf</File>
<AllowOverwrite>true</AllowOve
</Backup>
3. Replace the DatabasesID with the Analysis Service database name which you want to backup.
Backup Using XMLA Query Editor:
1. Open the XMLA Query Editor using the New Query Option.
2. Enter the below query.
<Backup xmlns="http://schemas.
<Object>
<DatabaseID>Test</DatabaseID>
</Object>
<File>E:\Test.abf</File>
<AllowOverwrite>true</AllowOve
</Backup>
3. Replace the DatabasesID with the Analysis Service database name which you want to backup.
4. And replace the File to where(location on disk) you want the analysis service database to be backed up to.
5. Execute the Query.
3 comments:
The above query provided helped a lot for taking backup for one database at at time..
Can you guide me to take backup for all database at at time.....
in SSAS.
Thanks in advance.
You have to write query for all ur databases and put it in a job.
Aivivu - đại lý chuyên vé máy bay trong nước và quốc tế
săn vé máy bay giá rẻ đi Mỹ
đăng ký về việt nam ở mỹ
đặt vé máy bay từ nhật về việt nam
vé máy bay từ đức về việt nam
vé máy bay từ canada về việt nam
vé máy bay vietjet từ hàn quốc về việt nam
khách sạn cách ly
chuyen bay chuyen gia trung quoc
Post a Comment