By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,077 Members | 2,121 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,077 IT Pros & Developers. It's quick & easy.

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

P: n/a
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 ***
Jul 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 ***
Jul 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.