Restore SQL 2008 DB from tranaction logs

Mayogroup
Mayogroup used Ask the Experts™
on
Here is the situation.

One of our databases was corrupted. We were running nightly backups of the database.
But we do not have sufficient capacity to run Tranaction log backups.

Our Db backups from the past 3 nights were not able to be restored (I assume the corrupted DB was backed up each night).

I was able to restore to our DB backup from 4 days ago. Next step is to utilise transaction logs to bring the content back up to where is was last night.

I understand that without nightly transaction log backups this is not possible. However, is there any 3rd party tools available which can provide a solution for this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Som TripathiDatabase Administrator
Commented:
When you found db was corrupt, you should have taken a log backup before restoring 3 days old full backup.
Now, this is not possible to get those transactions. Any third-party tool can not get something which is out-of-picture.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial