title: Create a backup without a transaction log
body: <p>I have been given a backup of a SQL Server 2008 database in the form of a 150mb .bak file.</p>
  
  <p>When I attempt to restore it to another server it attempts to secure 170gb+ of data, I am assuming this is due to a completely unreasonable transaction log size.</p>
  
  <p>Unfortunately I do not have that much space on my VM to just restore it, so I have restored it on my local machine and after 3 or so hours of "100% complete, loading" it has finally restored.</p>
  
  <p>So... the question is, how do I make another backup of this DB WITHOUT THE TRANSACTION LOG on SQL Server Management Studio Express 2014?</p>