How to attach a database to a lost or damaged NDF File

In the forum, we can see that the NDF file is lost and there is no backup, so we cannot attach the database. I have also seen many answers on the Internet that the append fails without NDF. In fact, I tested it myself, even if there is no NDF.

In the forum, we can see that the NDF file is lost and there is no backup, so we cannot attach the database. I have also seen many answers on the Internet that the append fails without NDF. In fact, I tested it myself, even if there is no NDF.

Someone has encountered this problem on the forum.

5120 1024

5120 1024

1024 2048 10

10

10

10

Now we can see that all three tables exist, but the following error occurs when accessing the test1 table:

Msg 8653, Level 16, State 1, Line 1

The queryprocessor is unable to produce a plan for the table or view 'test1' because thetable resides in a filegroup which is not online.

Because the Filegroup in which the table is located is offline and has a website space, it cannot be accessed.

This article is from the "Pay attention to SQL Server Technology" blog, U.S. servers, and U.S. space. Please keep this source