I'm having difficulty trying to restore a SQL Server 2012 database to a new location and name. This used to work fine in SQL Server 2008 but no longer works and it leaves my original database in a (restoring...) state.
The reason I'm trying to do this is so I can have the exact same database as my client for comparative purposes. I restore my own database to another name and then restore my client's database over my original. I'm trying to do this using SQL Server 2012 Management Studio.