Operational Defect Database
BugZero found this defect 608 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 14989388
The non-primary filegroup misses all files after you restore the clone database to SQL Server 2017 and change it to read-write mode. Additionally, you receive the following error message when you try to insert data into a table: Msg 622, Level 16, State 3, Line <LineNumber> The filegroup "<FileGroupName>" has no files assigned to it. Tables, indexes, text columns, ntext columns, and image columns cannot be populated on this filegroup until a file is added.
Last update date:
9/20/2022
Affected products:
SQL Server 2017 on Linux
SQL Server 2017 on Windows
Affected releases:
build lower than 14.0.3456.2
Fixed releases:
14.0.3456.2
Description:
The non-primary filegroup misses all files after you restore the clone database to SQL Server 2017 and change it to read-write mode. Additionally, you receive the following error message when you try to insert data into a table: Msg 622, Level 16, State 3, Line <LineNumber> The filegroup "<FileGroupName>" has no files assigned to it. Tables, indexes, text columns, ntext columns, and image columns cannot be populated on this filegroup until a file is added.
