SQL Server Performance Forum – Threads Archive
Point of Time RecoveryHello Frinds, One of our client using sql server.
They had some corruption at some point on 20th March, 2007 in their SQL Server Database.
They detected this Yesterday.They dont have any full/transaction log backup to recover that point of time. But the LDF file is there. Is there any way to restore the data till 20th March using LDF file? How do I ‘read’ a log file to know what transactions happened on 20th? Thanks,
you can try third party tool,
like Lumigient Log Explorer
or APEX SQL LOG to view log file
Means u must go for third party tool.
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
If you do not have any Backup ,, then yes you will have to go through third party tool AKTHAR
Third party tools will not work if the database recovery model in SIMPLE mode OR if the database log truncated… MohammedU.
Thanks for update.
What recovery model are you usiing on the database? AKTHAR
I am using full recovery model.
Ok. Then you can try the Third party tools!!! AKTHAR