NDF and MDF data backup

Our server crashed. I was able to boot up in safe mode and copy the data
onto an external USB harddrive, all except our MDF file - i was able to
copy the 9 other NDF files and the LDF file. Our MDF file has very
little of our data, but i know it has SQL information in it.
What are my options on a restore? Can i create a new DB on the new HD
(which will create all NDF, LDF, and MDF), and then stop SQL, copy the
NDF and LDF from our USB drive, and then start up SQL again, and will
that work?
Remember, the files are just copied, not any kind of SQL backup.
TIA
Darin
*** Sent via Developersdex http://www.codecomments.com ***
As far as I know you have any luck to get your database back using only ldf
and ndf files.
Are you sure you do not have a backup of your database anywhere in the
cabinets in your room, hmm?
You didn't mention what kind of a crash it is, however have you tried some
kind of File Recovery software to try to recover that mdf file?
I hope another friend of mine here has to say something to recover it...
Ekrem nsoy
"Darin" <darin_nospam@.nospamever> wrote in message
news:%23YFrJRiIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> Our server crashed. I was able to boot up in safe mode and copy the data
> onto an external USB harddrive, all except our MDF file - i was able to
> copy the 9 other NDF files and the LDF file. Our MDF file has very
> little of our data, but i know it has SQL information in it.
> What are my options on a restore? Can i create a new DB on the new HD
> (which will create all NDF, LDF, and MDF), and then stop SQL, copy the
> NDF and LDF from our USB drive, and then start up SQL again, and will
> that work?
> Remember, the files are just copied, not any kind of SQL backup.
> TIA
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
|||we do have a backup, but it is to a DAT drive that this other server
doesn't have a drive on. I am getting a new HD to put in the original
server, where that HD crashed, just trying to get up and running now.
I do have a backup of older data (MDF, NDF, and LDF) on my machine and i
tried to do what i wanted and couldn't get it to work. After creating
the new database, and then coping over the old MDF, when i restarted
MSSQLSERVER, the enterprise manager showed the database, but there isn't
a + sign next to it, so there are tables, views, etc. strange.
Darin
*** Sent via Developersdex http://www.codecomments.com ***