Please reference my [Backup all Analysis Services databases to drive] stored procedure code under [Resources > Scripts > Backup / Restore] from the sqlservercentral.com main page.

We have this Analysis Services backup stored procedure...

You may have to add "C:\Program Files\Microsoft Analysis Services\Bin" to the PATH statement on the server in order for SQL Server to find msmdarch.

I have submitted a stored procedure...

In SQL Server Books Online, look for "linked Analysis servers > adding".

This should give you the values you need to add for a linked Analysis Server.

Another solution we have used is to force one transation to be replicated each day in order to prevent the subscription from being inactivated.

Once a day, we insert a dummy...