| Author |
Topic |
|
automicgina
Starting Member
25 Posts |
 Posted - 2005-05-20 : 11:51:42
|
| Hi all, I updated a table by mistake and then found out the database was never backup. The database is set to full recovery mode. Is it possible to restore my database from the log file back to the point before I update by mistake? I tried the "point in time" option but it keep saying that "The time specified is less than the minimum point..." Any suggestion is appreciated. Thanks. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-05-20 : 12:27:59
|
| Nope - until the first backup uis taken the recovery model is simple.The logs will be truncated on checkpoint until the full backup then they will be available for backups.==========================================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. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-22 : 22:37:59
|
| if you have a full backup plus the log backup you have right after you discovered the mistake, it is possibleotherwise, not possible. If this is the case, explore Log readers as solution to your problem--------------------keeping it simple... |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-05-22 : 22:44:42
|
| Log readers need a log - if the database has never been backed up then the log will have been truncated.==========================================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. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-22 : 23:16:31
|
| if it's in full recovery mode, unless it was truncated, the log should be intactsome log readers can read online log files (try apexsqllog, there's a trial version)--------------------keeping it simple... |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-05-23 : 00:34:12
|
| Hi,There is one more tool you can use to read log file i.e. Logexplorer (http://www.lumigent.com/products/le_sql.html). RegardsSachin |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-05-23 : 06:15:57
|
| >> if it's in full recovery mode, unless it was truncated, the log should be intactNo. Even if the database is in full recovery mode the log will be truncated on checkpoint until the first full backup is taken.You can't recover logs without a ful backup so there is no point in having the log (well apart from using log explorers but ms didn't cater for that).Anyway if a full backup has not been taken ever the database will act as if the recovery model is simple (may depend on service packs as I don't think it's documented).==========================================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. |
|
|
|
automicgina
Starting Member
25 Posts |
Posted - 2005-05-24 : 12:10:48
|
| Thank everyone for the suggestions. I tried Jen's suggestion and I'm able to use a log reader to read the file and get these data back. Thank you so much, Jen! |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-24 : 21:54:50
|
no problem, but create maintenance jobs now so that you won't have to go through the logs again  i don't know about you but it was a horrific experience for me  --------------------keeping it simple... |
|
|
|
|
no backup but in full recovery mode