Error Specified cast is not valid. (SqlManagerUI)

Question

Hi,

I have a backup of DB with version Microsoft sql 2012 and i need restore this data base on instance Microsoft sql 2008 R2

when i try restore database on SQL server 2008 R2  i have the error:

Specified cast is not valid. (SqlManagerUI)

Answer 1

Hi,

I have a backup of DB with version Microsoft sql 2012 and i need restore this data base on instance Microsoft sql 2008 R2

when i try restore database on SQL server 2008 R2  i have the error:

Specified cast is not valid. (SqlManagerUI)

Answer 2

Hello,

Restoring to an earlier version of SQL Server is not supported. This is equivalent to a downgrade, and is not supported.

Try Import/Export Wizard.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 3

Alberto wants to say that you cannot restore backup taken on SQL Server 2012 (higher version ) on SQL Server 2008 r2 (lower version) this is not allowed by Microsoft

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Wiki Article
MVP

Answer 4

Hi MJMM12,

Besides other posts, you can use the Generate Scripts wizard to move the database from SQL Server 2012 to SQL Server 2008 R2.  The basic steps are as follows.

•Script the database schema  and data in SQL Server 2012 by using the Generate Scripts wizard of SQL Server Management Studio interface.

•Connect to SQL Server 2008 R2, and then run the SQL scripts that were generated in the previous step, to create database schema and copy data.

Also you can choose to use other methods such as SQL Server Integration Services or BCP to move the database from a higher version of SQL Server to a lower version SQL Server.

Reference:
http://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/


Thanks,
Lydia Zhang

---

Lydia Zhang
TechNet Community Support