Link to home
Start Free TrialLog in
Avatar of gerrymac1943
gerrymac1943Flag for Afghanistan

asked on

restore MS SQL Server backup error - specified cast is not valid (SqlManagerUI)

I'm trying to restore a backup into a blank database i.e. no tables. I get the following error

Specified cast is not valid (SqlManagerUI)

Is this because there are no tables in the database?
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Try applying SQL Server 2008 SP1 which might help sometimes.
As a faster fix, try restoring backup directly using TSQL statement which would work:

http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/9f29c16b-d783-406e-94f2-22720b8993b4
ASKER CERTIFIED SOLUTION
Avatar of lundnak
lundnak

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gerrymac1943

ASKER

thanks