title: How to attach MDF with no log file?
body: <p>I'm trying to attach <code>Yafnet.mdf</code> in SQL Server Management Studio, which does not have a log file. </p>
  
  <p>I get the error below. Any ideas how this can be done?</p>
  
  <blockquote>
    <p><em>An exception occurred while executing a Transact-SQL statement or batch.
    (Microsoft.SqlServer.ConnectionInfo)</em></p>
    
    <p><em>Unable to open the physical file "C:\sql_logs\YAFnet_log.ldf". Operating system 
    error 2: "2(The system cannot find the file specified.)". 
    (Microsoft SQL Server, Error: 5120)</em></p>
  </blockquote>