Menu
I have a backup from database in SQL Server 2008 R2. When I want to restore this backup to SQL Server, I get this error: "Error: Specified cast is not valid. (SqlManagerUI)" How to I resolve this error? Thanks.
228
Restore a Database Backup to an earlier version in SQL Server. The simple solution to achieve that is to use “Script and Data Generator Wizard” to create T-SQL script, then run it at the destination SQL Server with earlier version.
Explanation: DECIMAL is not a valid SQL type because it is nothing but numeric only in SQL.
Occurs once per compilation. Deprecated encryption algorithm rc4 will be removed in the next version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it. The RC4 algorithm is weak and is only supported for backward compatibility.
This would also happen when you are trying to restore a newer version backup in a older SQL database. For example when you try to restore a DB backup that is created in 2012 with 110 compatibility and you are trying to restore it in 2008 R2.
170
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
