SQL Server database restore error: specified cast is not valid. (SqlManagerUI) January 18, 2023 by Tarik Could be because of restoring SQL Server 2012 version backup file into SQL Server 2008 R2 or even less.