Backup From Log Files

[mazhar_83]

I want to restore data in a database using another computers database log files. How can I do that..........?

[amirtai]

Hi

Can you please elaborate your question. Are you trying to apply logs from primary database to standby database? or it's a raplication issue.

Thanks

[mazhar_83]

Hi,
e.g. I install my database on D:\ and my OS on C:\. Some how my OS crashes, I have log files on D:\. I need to get back all the data stored in my database which is actually in those files. If I install database and replace these log files my database can't work. I guess there must some way to solve this problem. So please reply if any one knows

Thanks

[amirtai]

Hi there,

You need to perform PIT (point in time) Recovery. As long as you provide your correct archive log files required by database you'll be able to recover as much as data. That's called roll forward and once you are finished with all of your archive log files it'll perform rollback of all uncommited transaction from redo log files.

Have fun.
Amir