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


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

<div>
<div class="content wysiwyg-content">
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?<br />
<br />
Windows Server 2003, SQL SERVER 2008 R2<br />
<br />
Any help will be most appreciated. <br />
<br />
Thanks.
</div>
</div>


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. 

Thanks.

I have .MDF and .TRN

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.