Thursday, April 15, 2010

Backup cube role settings

Open this folder:
[MS AS Data folder]\ [Database name]

Backup files with .role extension
**UPDATE**
It won't work! Copying .role files cannot restore role settings.

Alternative:
Creating cube role using script ** NEVER TRIED YET **
Google: automate|script cube role sql 2000

DSO Script: Adding a Role to a Cube
http://geekswithblogs.net/darrengosbell/archive/2006/06/13/81702.aspx

No comments:

Post a Comment