Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 missing ndf/mdf file
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 07/29/2006 :  01:55:06  Show Profile  Send anupam_sharma a Yahoo! Message  Reply with Quote

Recently my server harddisk crashed and I Lost a one of the secondary data files of sqlserver database.
I have the main file intact and the recent data was also in that file only, but I was unable to attach the database as it required the other data files also.

Is there any way to create the database again from the existing data file( unfortunately there is no backup also which we can use to recreate the missing data file)



United Kingdom
22859 Posts

Posted - 07/29/2006 :  05:03:53  Show Profile  Reply with Quote
If you have multiple data files and no backup then I reckon you are hosed when you lose one datafile.

If you haven't already done please put a robust backup strategy in place

Go to Top of Page

Yak with Vast SQL Skills

899 Posts

Posted - 07/29/2006 :  21:23:40  Show Profile  Visit paulrandal's Homepage  Reply with Quote
Nope - if you've lost a data file then you've had it.

I *really* must start a company recovering data for people who get themselves into this kind of mess needlessly...

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page


United Kingdom
12543 Posts

Posted - 07/29/2006 :  21:38:17  Show Profile  Visit nr's Homepage  Reply with Quote
I think maybe a premium rate phone service to deliver a recorded message
"Take and test regular backups if you don't want to lose your data"

(Took a few attempts to get it to be that polite.)

I keep telling companies that the frequency of tested backups corresponds to how much data they are happy to lose and that putting in a system without any backups means they are happy to rebuild it from scratch but they never listen.

Had one recently where I said I could put a backup process in place just in case - would take about 5 mins.
The response was they would form a project to decide what to do about it.
Two nights later they lost the database - took about 4 weeks to recover from it.
The IT manager at the next managers meeting said it was a good thing because they have now know about the risk so it was progress.
I was at the meeting but he carefully didn't look at me.

Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Edited by - nr on 07/29/2006 21:44:16
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000