Monday, February 20, 2012

NDF and MDF data backup

that is my problem, i don't have the MDF. I created a new DB and tried
to copy just the NDF and LDF and keep the new MDF and attach the DB and
it didn't work.
I have a new HD and will hopefully be able to restore from the tape
backup.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
My guess is that the master db is in your .mdf file. Without that, you're
kinda toast.
"Darin" <darin_nospam@.nospamever> wrote in message
news:usJ7KgkIIHA.4296@.TK2MSFTNGP04.phx.gbl...
> that is my problem, i don't have the MDF. I created a new DB and tried
> to copy just the NDF and LDF and keep the new MDF and attach the DB and
> it didn't work.
> I have a new HD and will hopefully be able to restore from the tape
> backup.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
|||In a message of yours you have MDF file of your database and in another you
say you do not have it.
Creating a database from scratch and copying your other databases NDF and
LDF files and using the new database's MDF file would not work. It doesn't
work like that. You need the MDF file of your original database. If not,
then you have to use your backup to restore your database.
Ekrem nsoy
"Darin" <darin_nospam@.nospamever> wrote in message
news:usJ7KgkIIHA.4296@.TK2MSFTNGP04.phx.gbl...
> that is my problem, i don't have the MDF. I created a new DB and tried
> to copy just the NDF and LDF and keep the new MDF and attach the DB and
> it didn't work.
> I have a new HD and will hopefully be able to restore from the tape
> backup.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***

No comments:

Post a Comment