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/

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  February 22, 2020 at 8:10 am

  #3727879

  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: 36096

  More actions

  December 22, 2021 at 7:47 am

  #3966198

  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

• June 25, 2022 at 11:31 am

  This was removed by the editor as SPAM