title: How to restore database with 2 mdf and 2 ldf files leaving only 1 mdf/ldf pair?
body: <p>I've got a .bak file (SQL Server 2008) which contains 2 mdf and 2 ldf files.</p>
  
  <p>When I try to restore a database from it, it creates all 4 of those files.</p>
  
  <p>I've never seen this before, and was wondering how do I go to the good-old 1 file pair system (1 mdf/1 ldf)?</p>
  
  <p>Any insight on 2 file pairs being in the backup will help as well.</p>
  
  <p>p.s.: my setup does not have any Ndf files, both are Mdf</p>