title: Restore SQL Server database in same pc with different name
body: <p>I have:</p>
  
  <p>SQL Server 2008</p>
  
  <p>Database Name: database1</p>
  
  <p>I had taken backup from "database1" nearly one month ago. Now, by someway, "database1" is messed up in some tables.</p>
  
  <p>So I want to recover only those tables from my last backup.</p>
  
  <p>I am trying to make another database named "database2" and restore on it with old backup.</p>
  
  <p>I'm afraid to restore from backup file, which may restore in "database1", I want to re-store in only 'database2' (which is new)</p>