This article is in response to a comment in my previous article “SSAS Database Backup”, the user said that he wants to take the backup of the analysis services database to a custom location and he could not exactly figure it out. When you are in taking the backup of a SSAS Database, and when yu are in the SSAS Database Backup dialog box, then you will see a message
“The server property, AllowedBrowsingFolders, determines which folders appear in this dialog box. To add or remove folders from this list, open the Analysis Server property box, and then edit the AllowedBrowsingFolders.”
Let’s follow the message and get our task done…
- Open management studio and connect to the desired instance of analysis services/ desired server.
- Select the particular instance you want to check the properties for and right click and select the properties option
- Now you have a new window where you see a list of properties, with fields for Name, Value, Current Value, Default Value and if a restart of the analysis services is required if the particular property is changed.
- At the bottom you have a couple of check boxes one being “Show Advanced (All) properties”, check this box.
- Now at the beginning of the list of the properties, you will find “AllowedBrowsingFolders”, Now select the value field, press end, and first add a pipe symbol to tell the analysis services that you are adding a new folder in the list of folders which can be browsed(“|”), and add the full folder path, and press “OK”.
SSAS Properties Allowed Browsing Folders
That’s it when we go to the backup dialog box, we can see the newly added folder in the list of folders!!!
If you have liked the article and want to get the articles (or) new posts at sql like, subscribe to articles through email by entering your email address in the top right and verifying the same. If you have any comments, then the below form is for you, go ahead!!!
Comments on this entry are closed.