• Hi Theo,

    I am successfully backing up SSAS databases following you idea.

    It was definitely not straight forward, I had a few issues

    as you can see here

    and also here

    But in my case:

    1) I don't have sql server installed on the same machine that I have ssas

    2) I don't have ssas installed on the same machine that I have sql server

    Now the new challenges are:

    1) how do you do a RESTORE VERIFYONLY in SSAS

    2) how do you do a DBCC CHECKDB in SSAS

    Another thing that I needed done is to delete old SSAS backup files.

    this you can see on this link, I have done it using PowerShell, from a remote computer.

    It deletes files older than 2 days.

    All the scripts are there.

    regards

    Marcelo