title: How to restore to a different database in SQL Server?
body: <p>I have a backup of <strong>Database1</strong> from a week ago. The backup is done weekly in the scheduler and I get a <code>.bak</code> file. Now I want to fiddle with some data so I need to restore it to a different database - <strong>Database2</strong>.</p>
  
  <p>I have seen this question: <a href="https://stackoverflow.com/questions/5228597/restore-sql-server-database-in-same-pc-with-different-name">Restore SQL Server database in same pc with different name</a> and the recommended step is to rename the original db, but I am out of that option as I am in the production server and I cant really do it.</p>
  
  <p>Is there any other way of restoring it to <code>Database2</code>, or atleast, how do I browse through the data of that .bak file?</p>
  
  <p>thanks.</p>
  
  <p>ps: the second answer from the above link looked promising but it keeps terminating with error:   </p>
  
  <blockquote>
    <p>Restore Filelist is terminating abnormally</p>
  </blockquote>