0

I have SQL Server 2014 installed on Windows and enabled the FileStream feature. I backed up the database to a .bak file. Now I want to restore the file to my Docker container of SQL Server 2019. However, when I try to restore the .bak file, it fails. I searched for a solution and found out that the FileStream feature is not supported on the Docker version of SQL Server. Is there any way to restore the .bak file to my Docker version of SQL Server?

Improve this question

1 Answer 1

Reset to default
0

The right answer is to remove the FileStream from the database before backing up. You can add a non-filestream varbinary(max) column to store the blobs in the database instead of in the file system.

See, eg How to Remove Filestream from a SQL Server Database

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.