Need to script out Analysis Services METADATA

Last Post 03 Feb 2010 06:32 AM by sumerian. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sumerian
New Member
New Member

--
03 Feb 2010 06:32 AM
Hi

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
You are not authorized to post a reply.

Acceptable Use Policy