Need to Script out Analysis Services METADATA

Last Post 03 Feb 2010 05:34 AM by sumerian. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

03 Feb 2010 05:34 AM

has anyone came across a script that will allow you to automatically script out Analysis Services databases to a file. Rather than backing up each of the analysis services database each night - I'd like to be able to script out the metadata to a file so that it could be used if we needed to re-create the database.

I know you can script out each database individually from management studio - however I'd like to run it so that if a new database is created it will automatically get scripted out as well.

Thanks in advance

Acceptable Use Policy