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 |
|
Hagai
Starting Member
2 Posts |
 Posted - 2004-05-25 : 04:15:27
|
| I have a database with recovery model set to full.Yesterday I did a mistake and deleted some importent data. I have an old backup of the database file but not for the transaction log. After I deleted the data the database was backed up again. Now I have a large transaction log but ofcourse only small part of him active. I used some transactoin log viewers but all show just the active part of the log. Is the anyway to recover the data up to the point I made the deletion?TIA,Hagai |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-25 : 12:25:52
|
| You can only recover the data if you've got a transaction log backup that has the data, which it sounds like you don't.Tara |
 |
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2004-05-25 : 13:06:54
|
| As Tara stated, without a transaction log backuop, you cannot recover that data in between the time of your last backup and the deletion.In case this happens again, immediately take a transaction log backup and note the time the delete occured so that you can recover to just before that time.-JonJust a starting member. |
|
|
|
Hagai
Starting Member
2 Posts |
Posted - 2004-05-27 : 00:36:38
|
| Thanks.Hagai |
|
|
|
|
|
|
Recovering Data