1. Home
  2. Database
  3. SQL Server
  4. SQL Server Error Messages
  5. “Specified cast is not valid. (SqlManagerUI)” – SQL Management Studio Error Message

“Specified cast is not valid. (SqlManagerUI)” – SQL Management Studio Error Message

Summary

This Error Message Article explains the Microsoft SQL Server Management Studio error message “Specified cast is not valid. (SqlManagerUI)” and details how to fix the underlying problem that caused it to appear.

Explanation

This message appeared when a client tried to restore a SQL backup file made from another instance of SQL using a newer version.

Solution

SQL is generally not backwards compatible.  The original back up file must be recreated in the same version of SQL that will restore it.

Additional Comments

Error First Appeared: Windows 7 running Microsoft SQL Management Studio 2008R2

Updated on August 1, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support