Error"Specified cast is not specified. (SqlManagerUI)" while restoring Database.
ScenerioI took database backup on SQL SERVER 2008 and tried restoring it on SQL SERVER 2008 R2. Ideally, it should work fine but while selecting backup file, SQL Management Studio 2208 R2 was raising error "Specified cast is not specified. (SqlManagerUI)".
Reason & TroubleshootThis was due to .BAK file corruption during FTP transfer (transfer mode is set to ASCII).
Always, remember to set FTP transfer mode to BINARY while transferring database .BAK file.