title: How do I attach a MSSQL 2000 database with only an MDF file
body: <p>I have an old server with a defunct evaluation version of SQL 2000 on it (from 2006), and two databases which were sitting on it.</p>
  
  <p>For some unknown reason, the LDF log files are missing. Presumed deleted.</p>
  
  <p>I have the mdf files (and in one case an ndf file too) for the databases which used to exist on that server, and I am trying to get them up and running on another SQL 2000 box I have sitting around.</p>
  
  <p><code>sp_attach_db</code> complains that the logfile is missing, and will not attach the database. Attempts to fool it by using a logfile from a database with the same name failed miserably. <code>sp_attach_single_file_db</code> will not work either. The mdf files have obviously not been cleanly detached.</p>
  
  <p>How do I get the databases attached and readable?</p>