Monday, February 20, 2012

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

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 ***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:

Quote:

Originally Posted by

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 ***

No comments:

Post a Comment