The Restore Database GUI won't accept filenames with leading whitespaces - by spaghettidba

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 2395147 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 2/23/2016 8:02:47 AM
Access Restriction Public


When choosing a restore media from the SSMS GUI, the file name is trimmed, so any file name with leading whitespaces is loaded incorrectly.
D:\MSSQL11.SQL2012\MSSQL\Backup\ test4.bak is loaded in the restore GUI as D:\MSSQL11.SQL2012\MSSQL\Backup\test4.bak (without the leading whitespace). 
This causes the restore window to throw "No backupset selected to be restored".
Sign in to post a comment.
Posted by Microsoft on 8/18/2016 at 3:57 PM
The issue has been fixed and will be available in release 16.4
Posted by spaghettidba on 2/23/2016 at 8:26 AM
Tested on build 12.00.4439 (latest and greatest to date) and I can confirm it is still broken.