November 18, 2005 at 8:42 am
This is relatively new table ...
I accidentally updated all the records to the same thing and there is no back ups. can I restore the table using the transaction logs?
Recovery is Full
Thanks mo
November 18, 2005 at 12:33 pm
Nope. To restore with a transaction log, you have to have a FULL backup. The transaction log backup only applies to the full backup done prior to the log backups.
-SQLBill
November 23, 2005 at 1:39 pm
You could probably use a log viewer program like Lumgents Log Explorer or ApexSQL Log. I believe they will work without a full backup. Lumgents reads the log file directly, I think Apex is based on triggers so it might not. Down side is it cost a $$$$.
November 28, 2005 at 7:15 am
Another downside of Lumgent's Log Explorer is that it has to be loaded and running prior to when you need to use it. It's not able to read log files made before it was installed. (Or so I have seen stated elsewhere).
-SQLBill
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply