In SQL Server Management Studio versions 2008 R2 and previous, the database name was always used as the default in the Physical File Name in the Restore database wizard, which was correct for our workflow. In SQL Server 2012, this appears to no longer be the case. Now, the name of the original database appears to be the default file name, which causes us to have to change the file names manually to the correct database name when restoring a new database. If these changes are not made, then there are either errors in the restore process or the Physical File Name of the database and log files are incorrect, which means our DBAs have to constantly make sure that the file names are correct on the database server, which involves taking databases offline if they are not.
Operating System Language
Steps to Reproduce