For what it's worth, I have reported this on
https://feedback.azure.com/d365community/idea/212a7e0e-bc50-ed11-a81b-000d3adfeb99.
Adding file to filegroup containing filestreams does not work in SQL Server 2022 RC1 Express Edition
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:
- Install SQL Server 2022 RC 1 Express Edition with Filestream Feature
- Run the following script in SQL Server Management Studio
- 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 - 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)
7 answers
Sort by: Most helpful
-
Erland Sommarskog 111.1K Reputation points
2022-10-20T21:18:13.607+00:00 -
Salah fazai 1 Reputation point
2022-10-19T21:52:32.55+00:00 Installer ou ajouter une table ou unficher
-
PandaPan-MSFT 1,916 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:
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"
-
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
-
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)