Error: Specified cast is not valid. (SqlManagerUI)

sql-server-2008-r2 database-restore
Tavousi picture Tavousi · Apr 10, 2012 · Viewed 120.7k times · Source

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.

Answer

user1089020 picture user1089020 · Jul 29, 2013

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.

Related questions

Database stuck in restoring state

Last night I had a database that had it's data and log files physically removed without first taking the proper steps to move the database files. After the disk were physically reattached, the database went into "Restoring..." state. I have …

Read More
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated

I have many users on my web site (20000-60000 per day), which is a download site for mobile files. I have remote access to my server (windows server 2008-R2). I've received "Server is unavailable" errors before, but am now seeing …

Read More
Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on …

Read More