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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoring *.mdf file only

Author  Topic 

royv
Constraint Violating Yak Guru

455 Posts

Posted - 2001-10-15 : 10:57:58
I have a full backup that I would like to restore, except I only want to restore the *.mdf file, I DO NOT want to restore the log file, *.ldf file. I haven't been able to succesfully do it, and I'm not sure you can. Has anyone done this before, or any ideas?

   

- Advertisement -