Im running a script but it always fails with the error:
Executed as user: Administrator. The filegroup "DData" 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. [SQLSTATE 42000] (Error 50000). The step failed.
I Check the database im running the script against and it appears ok:
I can see the filegroup and all the physical files are there
Screenshots attached (show file group and location of physical files)
So what could be the problem? Could the files be corrupt?