We help IT Professionals succeed at work.

I have .MDF and .TRN

vrosas_03 used Ask the Experts™
I need to restore a Database to a certain point in time. However, I only have a .MDF and .TRN files, no .LDF. Can I use the .TRN to create a useful .LDF? My .MDF is dated 4/2/2012 5:33AM and I have a TRN at 4/2/2012 5:00AM. However, I want to go as close to 4/1/2012 as possible, can I use my TRN with 4/1/2012 8PM and my .MDF dated 4/2/2012 5:33AM?

Windows Server 2003, SQL SERVER 2008 R2

Any help will be most appreciated.

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012
Can I use the .TRN to create a useful .LDF?
if TRN is the default Transaction Log backup extension and you do not have a Full Backup than the answer is no.  If that is the case and you do not have the Transaction Log files, you just may be able to ATTACH the data file (your .MDF) and the Transaction Log file will be recreated using the ATTACH_REBUILD_LOG switch.  But at the very best you have the strong possibility of losing data.
you can just attach your mdf file without no problem, but as you mdf file is a newer one ,you can't roll backup to the older date


I guess the simple answer is NO. I wasn't able to restore the .LDF with the TRN's.