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 |
|
debug2k
Starting Member
18 Posts |
 Posted - 2004-04-26 : 04:54:28
|
| Hi ,One of my database is showing suspect as the ldf is missing. Is there any way i can restore the database with MDF only.Regards, |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-04-26 : 05:42:09
|
| Read BOL on Topic 'sp_resetstatus'- Sekar |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-26 : 08:13:33
|
| Are you wanting to restore the database from a backup, or just get what you have working???MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-26 : 12:39:10
|
| sp_resetstatus will only work if the database is still intact. Which it isn't, since the LDF is missing. You can try attaching the database with sp_attach_single_file_db, but I'm not sure that it will work since you didn't first detach it. Do you have a recent full backup? Please say you do!Tara |
|
|
|
debug2k
Starting Member
18 Posts |
Posted - 2004-04-26 : 13:42:01
|
| NO Tara... I dont have it..... the backup is not there...Is there any way that we can trick SQL Server.. by somehow creating a dummy LDF...Regards,Deepak U |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-26 : 13:42:53
|
| Yes with sp_attach_single_file_db. Have you tried that yet?Tara |
|
|
|
|
|
|
LDF missing