Physical File Names in the Database Restore Wizard Should Default to Database Name - by Matthanielcm

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 777310 Comments
Status Closed Workarounds
Type Bug Repros 2
Opened 1/23/2013 1:59:38 PM
Access Restriction Public


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.
Sign in to post a comment.
Posted by Mazhar A Shaikh on 5/26/2013 at 6:50 PM
Not sure why this is in a Closed state, without any details in the Comments section as to what version or update has fixed this issue.
Posted by Microsoft on 1/29/2013 at 4:31 PM
Thank you for reporting this issue - we are investigating and will update you when we have more information.