This PowerShell script will connect to an SSAS instance, enumerate ALL databases, and back each one up. You can then add this to either as a Scheduled Task or as a SQL Agent job.
One of the challenges weve faced is changing passwords in a warm server to reflect changes made to the live server. The initial transfer of users and passwords was performed by the sp_help_revlogin script provided by Microsoft at http://support.microsoft.com/default.aspx?scid=kb;en-us;246133. The difficulty with this script was once the users are in place, you cant sync changed […]