I found out the root cause, and this was not the antivirus.

A few weeks ago, we tested the possibility to migrate an SSAS DB to a fileshare. It did...

• This reply was modified 2 years, 9 months ago by  iz.
• This reply was modified 2 years, 9 months ago by  iz.
• This reply was modified 2 years, 9 months ago by  iz. Reason: link to fileshare post

We ran a few more tests trying to restore an SSAS backup to a fileshare. The XMLA command failed every time with the "File system error" and same file path...

I have looked further into the error and saw that it always stops on the same file, where path length is 288 characters.

That being said, the 255 character limit...

Thanks Paul. The ASSP is a top 1 answer for this problem. However, I needed to do this with bare SQL. Which I managed.

On a side note, I really...

Thanks Steve.

How would you sync the changes with a SQL instance? E.g. imagine you have a DEV environment and would like to have a single master version of procedures etc....

• This reply was modified 4 years, 6 months ago by  iz.