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 |
|
hdv212
Posting Yak Master
140 Posts |
 Posted - 2007-10-03 : 18:31:57
|
| hii was deleted a record from my database, but i want to recover my deleted record via log file, how to do ?thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-03 : 18:47:49
|
| Do you have any backups? If you don't, then you'll need to use a third party tool to read that transaction log file. Check out Lumigent's Log Explorer. Red Gate also has a tool. They are not free though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-03 : 22:23:35
|
| If db is in simple recovery mode, even third party tools can't help. |
|
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2007-10-04 : 02:18:59
|
| thanksis that any way for explorer log file mySelf and recover my lost data from it ? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-04 : 02:37:25
|
You could give this a shot!select *from ::fn_dblog(default, default)
E 12°55'05.25"N 56°04'39.16" |
|
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2007-10-04 : 06:57:26
|
| thanks PesoCan u give me More Explain or resource ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-04 : 11:27:55
|
| Good luck on fn_dblog. There's a reason why vendors create third party tools to read the transaction log!Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Recovery my database with log file.