title: Restoring SQL Server database using just the MDF file without LDF
body: <p>I have SQL Server 2008 R2, and I need to restore my database to another server but <code>backup.ldf</code> file has been corrupted, so is it possible to restore my database using just the <code>.mdf</code> file alone? Or is there any possibilities for creating the <code>.ldf</code> file manually?</p>