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 |
|
mallesh
Starting Member
7 Posts |
 Posted - 2007-04-24 : 06:15:31
|
| Hi friends,Please help me......The .ldf files in sql server 2000 was about 1.5 GB so I deleted that one. Now Database is not working.What shall I do now?and How to recover the .ldf file? I don't have the back-up. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
mallesh
Starting Member
7 Posts |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-24 : 14:17:33
|
| I hope you've learned your lesson. Do NOT delete SQL Server files unless you know they are no longer in use. The LDF file is very, very important. Also, start backing up your database! Don't assume that you'll never run into problems.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
.ldf file lost