View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
With the course of time, you might need to backup all the SSAS databases within a server instance automatically and schedule to backup these database monthly wise or according to your specific time set.
May be there are a lot of alternative methods to perform this task and many solution's. But I have researched a lot regarding to backup all the SSAS databases within a particular server instance dynamically.
Previously, I have shared “How to schedule and automate backup all the SQL databases within a server instance”.
Here ,I am going to show how to obtain all the cube databases backup automatically along with schedule time set.
These are the following steps you should have to follow.
1. Adding a linked server in SSMS.
You can simply add a linked server within a SSMS by using a script as
--Adding a linked server
@server = N'SSAS_Backup'
, @datasrc=N'ANILMAHARJAN' /* <<< My Analysis Services server name */
/* <<< My Analysis Services database name */
--Setup security as per your environment requirements.