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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-10 : 07:51:12
|
| Saurabh writes "hi,is it possible to recover data from .ldf file only. I lost my data file and i dont have previous backup." |
|
|
kish
Starting Member
45 Posts |
Posted - 2005-03-10 : 07:58:45
|
| No. YOu cannot recover from the .ldf file alone. You need to have a backup to restore if you have lost the .mdf file. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-10 : 18:01:08
|
| Well yes you can, but you'll need a third party tool such as Lumigent's Log Explorer to read the tlog.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-10 : 23:07:42
|
If the database is set to full recovery mode. Since you don't have a backup, you might have left it in full recovery mode on accident.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Recovering data