New answers tagged ssas
I found a post by Darren Gosbell, a SQL Server MVP (at the time at least). His post can be found here: http://geekswithblogs.net/darrengosbell/archive/2008/09/13/ssas-verifying-backups.aspx He points out that you cannot run this from your desktop, but you can run it on the server to do the verification. The instructions from 2008 are: Navigate to: ...
I have achieved this without any SSIS. I used a linked server instead. It took me some time, but I still believe it is the best way of backing up SSAS databases. You can see how I did it on this link. I also delete old backup files, as you can see on this link.
Top 50 recent answers are included