locked
change default backup directory for SSAS cubes RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Using SQL server 2014 standard edition.

    I am trying to change the change default backup directory for SSAS cubes, but I get this error:

    "

    TITLE: Microsoft SQL Server 2014 Analysis Services Managed Code Module
    ------------------------------

    The function failed because of the following error: The given path's format is not supported..

    ------------------------------
    "

    I clicked on the Analysis Service instance on SSMS and then select properties, General - Backup and trying to edit Value by clicking on that cell.

    How do I change the folder where the cube should backup?

    Thanks.

    Tuesday, April 17, 2018 1:57 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Once you open your properties, make sure you check (at the bottom) "Advanced"

    It opens more options to change paths.

    Additionally to those paths you see, you can add your own paths from your HDD. To separate one path to the next one your need the "pipe character" " | " for example: C:\Data | D:\Backups | E:\Logs

    Then you have to close your Management Studio and open it once again, so the new definitions would be identified.

    • Marked as answer by kvd123 Tuesday, April 17, 2018 9:40 PM
    Tuesday, April 17, 2018 6:42 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    The method you have described is how you would change this setting. What sort of value are you trying to enter? According to the error message it sounds like there is something wrong with the specific value you are entering. 

    I'm pretty sure that you can only use a path to a local drive (so no unc paths to remote shares). If you are using a path to a local folder make sure that the folder exits and make sure that the path does not include a trailing backslash  \. 

    http://darren.gosbell.com - please mark correct answers

    • Proposed as answer by alexander fun Tuesday, April 17, 2018 11:30 AM
    Tuesday, April 17, 2018 2:18 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi kvd123,

    Thanks for your question.

    >>>How do I change the folder where the cube should backup?
    For this issue, please refer to blow blog talking about all possible scenarios of changing SSAS data folder:
    https://blogs.msdn.microsoft.com/karang/2012/07/30/ssas-all-possible-scenarios-of-changing-ssas-data-folder/

    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Proposed as answer by alexander fun Tuesday, April 17, 2018 11:30 AM
    Tuesday, April 17, 2018 6:03 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I get this error as soon as I click on the little square on that cell. I have not even entered any value yet.

    What am I missing?

    Tuesday, April 17, 2018 6:30 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Once you open your properties, make sure you check (at the bottom) "Advanced"

    It opens more options to change paths.

    Additionally to those paths you see, you can add your own paths from your HDD. To separate one path to the next one your need the "pipe character" " | " for example: C:\Data | D:\Backups | E:\Logs

    Then you have to close your Management Studio and open it once again, so the new definitions would be identified.

    • Marked as answer by kvd123 Tuesday, April 17, 2018 9:40 PM
    Tuesday, April 17, 2018 6:42 PM