Specified cast is not valid during restoring a database from SQL Server 2012 to earlier version

In SQL Server 2008 R2, I tried to restore a database backup that has been taken from SQL Server 2012, by doing the following:

DBrestore

RestoreDB

But unfortunately, After clicking OK. I got the following error

Specified cast is not valid

Invalid cast

Cause:

The database restore operation is only allowed as a move forward that means, you can restore the database from 2005 or 2008 to 2012 version but it’s not applicable in reverse order.

Solution:

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.

3

Enjoy 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s