#generate xmla database creation script

Automating SSAS script only backups with C# for Tabular and Multi-Dimension Models

I was recently asked to create a SQL job to automate the backing up of our SSAS cubes from several servers but unlike the standard SSAS backups, the business didn’t want the data backed up, they only wanted the schema/code as they needed daily backups. The full backup with data would have used up too much space.

Initially, I thought it’d be a piece of cake, just had to Google it, right (while…