title: Restore data file from sql server backup file without restoring the log file
body: <p>I have a client who needs support with SQL Server. The client has provided a backup of the database. Upon trying to restore the database for testing, I realized that the data file is 100MB while the log file is 250GB which makes it impossible to restore on my development computer.</p>
  
  <p>I have seen it is possible to create SQL virtual databases using <a href="http://www.idera.com/SQL-Toolbox/" rel="nofollow noreferrer">idera SQL virtual database</a> and <a href="http://www.red-gate.com/products/dba/sql-virtual-restore/" rel="nofollow noreferrer">Redgate SQL Virtual Restore</a> but I haven't done any testing on these tools. </p>
  
  <p>Is is possible to extract or restore the data file (mdf) alone without the log file (ldf)?</p>