| Author |
Topic |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2007-10-22 : 10:54:25
|
| Dear GurusI want to restore my transaction log backup.(Latest Tlog Backup)I have tried to restore the backup in following waydatabase->tasks->restore-> transactionlog..But in my server the transactionlog option is grayed(disabled). Now how can i do restore. Am i wrong anywhere..?Please give me your valuable suggessions gurus.ThanksKrishna |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-22 : 10:58:42
|
| Is your database that you are wanting to restore it to in read-only mode and with recovery option left off...hence letting it know that there will be more stuff (t-logs) to restore? Is your t-log, that you are wanting to restore, the first log backup from your source database after the full backup? |
 |
|
|
Kristen
Test
22859 Posts |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2007-10-22 : 11:05:07
|
| Van thanks for your reply. It doesnt have more stuffs and This is not a first backup.By mistaken,One of our user has deleted the data in once table I want to rollback the data.But the deleted data doesnt exist in full backup. what is the step to recover the data.ThanksKrishna |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-22 : 11:17:20
|
| Lumigent log explorer. I haven't used it for a couple years but I remember it seemed like it was more of a detective tool than a data recovery tool. You could do data recovery but it seemed a bit tedious. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-22 : 11:52:09
|
| "Is there any tools available for recover data from log files..?"I usually restore the backup (FULL +Tlogs etc) to a separate, temp, database then "copy" the required rows to the "Live" database. Then drop the Temp database.Kristen |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-22 : 11:58:43
|
| Yep, that's the easier route. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-22 : 22:16:29
|
| Log Explorer is not a detective tool, and recovery with it is straightforward. |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-23 : 11:19:58
|
| Not in my experience. Maybe I had an older version or something. It was very tedious to use. Yea, there was the option to undo the transaction, but it seemed more like a detective tool to me. I didn't see much of a way to automate anything with it. I was being asked things like...have it spit out a report on a daily basis to tell us who changed what. I just didn't happen to find it very useful since we didn't have to undo/rollback commited transactions very often if ever. Maybe in other shops it's useful for their situation(s). |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-23 : 22:34:33
|
| If you like to do kind of auditing, it's wrong tool. |
|
|
|
|
Problem in restore transaction Log