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 |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2007-07-03 : 01:18:52
|
| Hi friends,By accident i have deleted the scmdb.ldf file.but scmdb.mdf file is there.just i need to restore the scmdb.mdf without the .ldf.whether it is possible?????? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-07-03 : 01:23:16
|
| Have you tried sp_attach_single_file_db ?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-03 : 12:54:52
|
| If that doesn't work, you can recover the db with good backup. |
|
|
|
|
|
|
restoring database