When automated restore is used to restore a database/indes with a filestream filegroup in it. Automated restore will append the file groups directory to the default SQL data directory and use that as the "filename"
This fails with an error such as the one below:
Base path 'C:\Program Files\Microsoft SQL Server\MSSQL11.CSRWORK\MSSQL\DATA\FS_newi:\1' is not a valid pathname in directory 'C:\Program Files\Microsoft SQL Server\MSSQL11.CSRWORK\MSSQL\DATA\FS_newi:\1'
