In Sql Server 2008 filegroup issue

Question

I have table1 in filegroup1, and when I use "select * from table1" Query then the error message

The query processor cannot create a table plan or view "table1" because the table is in a filegroup that is not on the network.

What are the solutions

Answer 1

There are several reasons why you get this error. First of all, an error occurs if you have a filegroup with a damaged or missing data file, so you can check this first.

state_desc sys.databases. RECOVERY_PENDING, , ( ), , .

ALTER DATABASE userDB MODIFY FILE (NAME=’damagedFile’, OFFLINE)

:

ALTER DATABASE userDB SET ONLINE

, . , .