Backup Ssas Databases with SessionTrace Output
User Rating: / 0
PoorBest 
Written by Olaf Helper   
Sunday, 30 October 2011 20:09

This Powershell backup's SSAS databases from a given list of db names. As backup file name the database name with a additional timestamp in format yyyy-MM-dd-HH-mm-ss is used. You can predefine a folder for the backup files, otherwise the default backup folder of the instance is used (BackupDir). Backup option "Apply compression" and "Allow file overwrite" can be set. Optional you can start a session trace to see the progress of the backup process. This script is doing only less validation and exception handling. Works with SSAS 2005 and higher versions in all editions. Requires Full Control (Administrator) permissions on the database to be backed up.

Read more...

 

 

XL Cubed