Invalid filegroup ‘…’ specified (Msg 1921)

[Total: 11    Average: 4.1/5]

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:

(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.