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)
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.