Error: Specified cast is not valid. (SqlManagerUI)
Description: While trying to restore a database using SQL Server Management Studio, this error dialogue box pops up. When we go for detailed error, there is nothing much helps us to identify the root cause of the problem. Before restoring we should follow below steps.
1. Make sure the source and target database server version is same or not.
2. Check whether the backup database copy is not corrupted.
RESTORE VERIFYONLY FROM DISK = N’C:\Backup\12345test.bak’
3. If using FTP transfer softwares to move the backup files, make sure to set the FTP transfer mode to BINARY from ASCII.