[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2010-08-25
3
Medium Priority
?
7,757 Views
Last Modified: 2012-08-13
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?
0
Comment
Question by:gerrymac1943
3 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33522482
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
0
 
LVL 7

Accepted Solution

by:
lundnak earned 2000 total points
ID: 33525003
SSMS is causing the issue.

Instead of hitting OK in the input window, click the Script Action to New Query Window button in the upper left hand corner of the window.

Try running this script from the command link instead.
0
 

Author Closing Comment

by:gerrymac1943
ID: 33590358
thanks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question