FileStream - Azure managed instance

Question

Post reply

FileStream - Azure managed instance

NicHopper

SSCrazy Eights

Points: 9090
More actions
February 21, 2020 at 7:59 am

#3727580

Hi,
Simple question, I know that FileStream is not supported in Azure DB single database or Elastic pools but is it supported in a managed instance?
I've tried to find a definitive answer but I'm getting conflicting info.
https://docs.microsoft.com/en-us/sql/relational-databases/blob/filestream-sql-server?view=sql-server-ver15
Says it only applies to SQL Server (Windows Only) and not Azure SQL Database
But
https://serverfault.com/questions/901892/migrating-filestream-database-to-azure
Says that a managed instance is an option.
Any help on clearing this up would be appreciated.
Thanks,
Nic

Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 25, 2022 at 11:31 am

This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 2

NicHopper wrote:

Hi,
Simple question, I know that FileStream is not supported in Azure DB single database or Elastic pools but is it supported in a managed instance?
I've tried to find a definitive answer but I'm getting conflicting info.
https://docs.microsoft.com/en-us/sql/relational-databases/blob/filestream-sql-server?view=sql-server-ver15
Says it only applies to SQL Server (Windows Only) and not Azure SQL Database
But
https://serverfault.com/questions/901892/migrating-filestream-database-to-azure
Says that a managed instance is an option.
Any help on clearing this up would be appreciated.
Thanks,
Nic

Filestream is currently not support by managed instance,to migrate an on-prem db with filestream enabled you have to store the file to blob storage and store the link to db in manged instance.

regards