Adding file to filegroup containing filestreams does not work in SQL Server 2022 RC1 Express Edition

David Wimmer 1 Reputation point
2022-10-19T12:14:15.607+00:00

Hi,

just tested SQL Server 2022 RC1 Express Edition and I am getting an undocumented error when I am adding a file to a filegroup containing filestreams.
This only fails in the Express Edition adding the file/filegroup to an existing database.
Does not fail in Evaluation Edition or Developer Edition.
Does not fail when creating the file/filegroup with CREATE DATABASE.

Steps to reproduce:

  1. Install SQL Server 2022 RC 1 Express Edition with Filestream Feature
  2. Run the following script in SQL Server Management Studio
  3. CREATE DATABASE [FS_Test]
    ON PRIMARY
    (NAME = N'FS_Test', FILENAME = N'C:\databases\FS_Test.mdf')
    LOG ON
    (NAME = N'FS_Test_log', FILENAME = N'C:\databases\FS_Test_log.ldf')
    GO ALTER DATABASE FS_Test ADD FILEGROUP fsGroup CONTAINS FILESTREAM
    GO ALTER DATABASE FS_Test ADD FILE (NAME = 'FS_Test_fs', FILENAME = 'C:\databases\FS_Test_fs') TO FILEGROUP fsGroup;
    GO
  4. After ALTER DATABASE ... ADD FILE the following undocumented error occurs.

Msg 35221, Level 16, State 1, Line 13
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.

The error is not listed database-engine-events-and-errors documentation.

The SQL Server installation ConfigurationFile.ini

----------

System Info:
Microsoft SQL Server 2022 (RC1) - 16.0.950.9 (X64) Sep 13 2022 13:09:32 Copyright (C) 2022 Microsoft Corporation Express Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,288 questions
{count} votes

7 answers

Sort by: Most helpful
  1. Erland Sommarskog 99,071 Reputation points MVP
    2022-10-20T21:18:13.607+00:00
    1 person found this answer helpful.

  2. Salah fazai 1 Reputation point
    2022-10-19T21:52:32.55+00:00

    Installer ou ajouter une table ou unficher

    0 comments No comments

  3. PandaPan-MSFT 1,896 Reputation points
    2022-10-20T05:43:02.38+00:00

    Hi @David Wimmer ,
    I think it might be the version problem, cuz the express version does not support some funtions like the following picture shows:
    252217-image.png

    You can check this official link, I hope this can be helpful.
    https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2022?view=sql-server-ver16


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"


  4. David Wimmer 1 Reputation point
    2022-10-21T08:10:08.353+00:00

    I already posted it there yesterday in the hope that someone there would take care of it.

    https://feedback.azure.com/d365community/idea/b35e9417-5e50-ed11-a81b-000d3a7c50ce

    0 comments No comments

  5. Clive 6 Reputation points
    2022-11-30T04:24:56.003+00:00

    The problem still persists for the recently released SQL Server 2022 Express edition (RTM version).
    Don't know whether this is because this GA version is built on Oct 8, 2022.

    Hope that this can be fixed in next cumulative update.

    select @@VERSION

    Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Express Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)

    0 comments No comments