SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

anupam_sharma
Starting Member

India
1 Posts

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

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)

thanks
Anupam

Kristen
Test

United Kingdom
22415 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

Kristen
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

USA
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

nr
SQLTeam MVY

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  
 New 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.05 seconds. Powered By: Snitz Forums 2000