Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anupam_sharma
Starting Member
1 Post |
 Posted - 2006-07-29 : 01:55:06
|
| 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)thanksAnupam |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-29 : 05:03:53
|
| 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 placeKristen |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-07-29 : 21:23:40
|
| 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 RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-29 : 21:38:17
|
| 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. |
|
|
|
|
|
|
missing ndf/mdf file