PowerPivot for SharePoint - move Analysis Services databases - file names(s) are larger than supported by file system RRS feed

  • Question

  • Hello,

    I am trying to move my existing PowerPivot Analysis Services databases to a different drive.

    https://blogs.technet.microsoft.com/mdegre/2012/10/03/moving-ssas-database-to-a-new-drive-on-same-server/ and  https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/move-an-analysis-services-database?view=sql-server-2017  

    PROBLEM: when copying the existing PowerPivot databases files to their new location I get "the source file names(s) are larger than is supported by the file system." - the only solution I have found is to shorten the path of the target - trying this ('E:\MSSQL\MSAS11.POWERPIVOT\OLAP\Data' is now 'f:\data' and I continue to have the issue - ANY SUGGESTIONS?

    Thank you for any assistance.


    Wednesday, December 12, 2018 6:30 PM