MS-SQL one .NDF file missing How to Recover/Rebuild DB??

[Dhungu Dhumbak]

Dear All,
SOS Please Help.
I have a MS-SQL DB with 4 .ndf files. One (first) .ndf file is missing.
somehow got deleted??. Is there any way can rebuild my DB.

The .MDF and .LDF files are in tact.
Please help asap.

Dhumbak

*** Sent via Developersdex http://www.developersdex.com ***

[Cimode]

It depends what this NDF was created for in the first place. If it was
storing indexes then you can rebuild these indexes. If it was data and
you have no backup on the filegroup then you probably lost your data in
loosing the NDF.
Dhungu Dhumbak wrote:

Dear All,
SOS Please Help.
I have a MS-SQL DB with 4 .ndf files. One (first) .ndf file is missing.
somehow got deleted??. Is there any way can rebuild my DB.

The .MDF and .LDF files are in tact.
Please help asap.

Dhumbak

*** Sent via Developersdex http://www.developersdex.com ***