Data Warehousing and Business Intelligence

10 September 2010

Q&A on: Browsable Folders When Restoring Cubes

Filed under: Analysis Services — Vincent Rainardi @ 10:54 am

Q: When restoring cubes, can I “browse” rather than “type” to select the backup file?
A: Yes, enter the folder path on the “AllowedBrowsingFolders” server property.

Q: Can I have more than 1 folders on that restore cube dialog box?
A: Yes, when entering the folder paths on the “AllowedBrowsingFolders” server property, separate them using a pipe (|).

Q: I entered 2 folders separated by |, but why only 1 appears on the restore cube dialog box?
A: That folder is invalid. Either a) typo on folder path in the server property, or b) that folder doesn’t exist. For example: “Log|Backup”, Backup gets deleted and now only Log appears on the restore cube dialog box.

Q: Can the backup file located on other server / file share?
A: Yes, for example \\server1\folder1\file1.abf. You need to have read permission on this remote folder. But no, you can’t add remote path like that on the  “AllowedBrowsingFolders” server property. If you do that it won’t appear on the restore cube dialog box.

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: