FILESTREAM

• Ronzo

  Hall of Fame

  Points: 3917

  More actions

  December 14, 2022 at 11:58 pm

  Go to Answer

  #4125756

  Trying to setup database with FILESTREAM. Using scripts that work great on previous versions of SQL Server (2016 to 2019). Getting strange error message when trying to add file to filegroup:

  Msg 35221, Level 16, State 1, Line 2

  Could not process the operation. Always On Availability Groups replica manager is disabled on this instance of SQL Server. Enable Always On Availability Groups, by using the SQL Server Configuration Manager. Then, restart the SQL Server service, and retry the currently operation. For information about how to enable and disable Always On Availability Groups, see SQL Server Books Online.

  We do not use Always On, so of course it is disabled. Why would SQL require it to be enabled for SQL 2022?

  Command being attempted is similar to this:

  ALTER DATABASE MyDb ADD FILE ( Name = FILESTREAM_Files, FileName = 'C:\Databases\SQL2022\MyDb') To Filegroup My_FILESTREAM;

  Also tried using SQL Mgmt Studio to do same, and get same error.

   

  • This topic was modified 2 years ago by  Ronzo.

  ---

  Have Fun!
  Ronzo
  

• Ronzo

  Hall of Fame

  Points: 3917

  More actions

  December 15, 2022 at 10:18 pm

  Answer

  #4126242

  Just got answer:

  This is a known issue. Microsoft has said that this will be fixed in CU1 for SQL 2022. The fix is also available in the RTM version of SQL 2022, but it is hidden under a traceflag, TF12324.

  Add it as a startup parameter in SSCM and restart SQL Server:

  ---

  Have Fun!
  Ronzo
  

• November 3, 2023 at 8:45 am

  This was removed by the editor as SPAM

• November 3, 2023 at 8:45 am

  This was removed by the editor as SPAM