“Invalid filegroup ‘…’ specified.” error can appear in the case when the name of Filegroup where the new Table_1 will be stored is invalid. Look at the syntax bellow:
CREATE TABLE Table_1 (Column1 int primary key, Column2 char(8)) ON [SecondaryFilegroup];
In this case, the user tried to store the new Table_1 into SecondaryFilegroup and received the following error message from SQL Server:
Msg 1921, Level 16, State 1, Line 1 Invalid filegroup 'SecondaryFilegroup' specified.
It means that such filegroup does not exist. The user has to create such filegroup or use another existing one to store the Table_1.
