This stored procedure will loop through all of the Analysis Services databases in the repository and back them up to a .cab file using the msmdarch command. A log file will be included with the backup.
There will be 2 days worth of backups saved to a local disk drive on the server.
It may be necessary to add "C:\Program Files\Microsoft Analysis Services\Bin" to the path statement on the server in order for SQL Server to find msmdarch when running the stored procedure as part of a scheduled SQL job.
Is there a way I can automate a file deletion process from within SQL Server?