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 |
|
ZarrinPour
Yak Posting Veteran
66 Posts |
 Posted - 2007-11-16 : 04:25:35
|
| Hi allI'm a newbie with SQl Server But somewhere i read that SQL server Data can be Recovered through *.LDF filesnow i want to know if i open a table in Enterprise-Manager and delete some records through DELETE statement ormanually, is it possible to recover those deleted records or not? if so how?Thanks in advance.Regards. |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2007-11-16 : 05:32:33
|
| You cannot recall only THOSE deleted rows. You have to restore the WHOLE DATABASE.Suresh B. |
 |
|
|
ZarrinPour
Yak Posting Veteran
66 Posts |
Posted - 2007-11-16 : 10:46:34
|
quote:
Originally posted by suresha_b You have to restore the WHOLE DATABASE.
Hi Suresh B.Thanks 4 ur reply.if i don't have any BackUp , so is it possible to recover those deleted records? through LDF file?Thanks |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-16 : 11:11:10
|
| No, that is why those .ldf backup files are there for. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 00:50:21
|
| You need third party tools for that. |
|
|
|
|
|
|
Recovering Data through *.LDF files