microsoft
Restore database backup onto mounted directory with FILESTREAM
I started up a container based on the microsoft/mssql-server-windows-developer image, with C:\Temp within the container mounted to C:\Temp on the host. I then tried to restore the WorldWideImporters sample database backups, changing the data file location to be C:\Temp. However, it choked on the FILESTEAM portion of the restore.
Error: Unable to open the physical file "C:\Temp\WideWorldImporters_InMemory_Data_1" Operating system error 0: "(null)"
Did you get anywhere with this? I'm getting :
Restore of database 'MyDatabase' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: FILESTREAM feature is disabled. (Microsoft.SqlServer.SmoExtended)
However I've enabled Filestream via Advanced Server properties in SSMS.
I'm getting the same issue. I'm trying to restore an existing database (2008 R2) into my docker instance and I'm getting this error : System.Data.SqlClient.SqlError: FILESTREAM feature is disabled. (Microsoft.SqlServer.SmoExtended)
Enabled Filestream via Server Properties in SSMS, restarted the docker, restarted the service, all without success.
Does anybody have some insight around how to fix this? I need to restore a database that uses FILESTREAM and also getting errors on restore
Msg 5591, Level 16, State 4, Line 2 FILESTREAM feature is disabled. Msg 3013, Level 16, State 1, Line 2 RESTORE DATABASE is terminating abnormally.
Enabling filestream without SQL server configuration manager is a huge pain.
Hi there, Filestream is not supported in SQL Server on Linux and Docker containers. Check out this link for more details - https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2019?view=sql-server-ver15#Unsupported
Hi there, Filestream is not supported in SQL Server on Linux and Docker containers. Check out this link for more details - https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2019?view=sql-server-ver15#Unsupported
Is this the linux version? Apologies. Im running the windows container. I got confused as the label on this issue states windows. I'm attempting to build a docker image with filestream installed along with sql server. This is how we learn I guess 😁
Ah my bad then, I assumed Linux container :) I don't have any experience with the SQL Windows containers.
I'm also running the Windows container and am struggling to het Filestream enabled:
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The path '/var/opt/mssql/data/Filestream01' cannot be used for FILESTREAM files. For information about supported paths, see SQL Server Books Online. (Microsoft.SqlServer.SmoExtended)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.46521.71+(SMO-master-A)&LinkId=20476
Not sure if this due to the same problem, but I had the same error and wasn't using a container. I eventually realized I was attempting to restore to a location on a virtual drive that was created from a folder by the SUBST command in Windows. Using the full non-virtual path to the folder I was restoring to allowed it to restore properly
