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 |
|
SMerrill
Posting Yak Master
206 Posts |
 Posted - 2003-06-12 : 16:54:06
|
I'm in deep fertilizer.  I inadvertently deleted all records from a table and there was no backup. What is a transaction log for, anyway? Is it possible to recover the lost information from the log alone? If so, how?--Shaun MerrillSeattle, WA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-12 : 16:58:49
|
| You can only use the transaction log if your database recovery model is set to FULL or BULK LOGGED AND you have the last database backup. And yes it is possible to recover without those, but you'll need Log Explorer for that [url]http://www.lumigent.com/products/le_sql/le_sql.htm[/url].A transaction log is used in conjuction with the backups to restore to a specific point in time. Say your last database backup was at 2am today. And your database failed at 4am, so you want to restore up to 3:59am. You would need the 2am backup plus any and all transaction logs before that time.Tara |
 |
|
|
SMerrill
Posting Yak Master
206 Posts |
Posted - 2003-06-13 : 17:37:18
|
| A MIGHTY tool indeed. Saved my backside!--Shaun MerrillSeattle, WA |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-13 : 18:33:52
|
| You mean the lumigent thing worked?Congatulations.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
SMerrill
Posting Yak Master
206 Posts |
Posted - 2003-06-13 : 18:38:31
|
Yep!! I just reversed the COMMIT TRANSACTION at the end of the log, and it wrote a SQL script for me to repopulate my table.High praise: Worth every penny.  --Shaun MerrillSeattle, WA |
|
|
|
|
|
|
Can I restore from a Transaction Log?