April 16, 2008 at 2:00 pm
jsut now i detect that there is no file with me to do essential recovery except the log file PLZ can any one till me can i recover from log file
April 16, 2008 at 2:08 pm
You'll need a log parsing program for that. Something like RedGate's SQL Log Rescue, or ApexSQL Log, or Lumigent's product (don't remember the name at the moment).
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 2:58 pm
yes am try to do that by this tools but it fail. do you remember other tool or other way plz
April 16, 2008 at 5:37 pm
Can you clarify your problem? Do you have a functioning database but no backups? What is the recovery model of the database?
Greg
April 17, 2008 at 4:00 am
ok my case here am replicate other database in my database and cause overwrite to hole data make big missing and i have not backup before only backup i take before 2 days for many reason now i have log file and old backup and i have to restor my data from it
April 17, 2008 at 7:27 am
If I'm not mistaken, the way to do what you're trying to do, is back up the log file, then restore the old database backup with "norecovery", then restore the log file onto it.
The section in Books Online on "Restore" has detailed instructions.
Try that, see if that does what you need.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply