none
Error: Specified cast is not valid. (SqlManagerUI) window server R2

    Question

  • I have a hyper v image, running on my window server 2008 R2 64bit.
    the image is 32bit server contain sql 2008 server.
    after i backup the DB (10GB) and try to install in another server by using Restore in SSMS UI, it prompt me error.
    Error: Specified cast is not valid. (SqlManagerUI)

    May  I know what is the cause of that and how to solve it?

    Does it have something to do with the 64bit / 32 bit different or NTFS / FAT different when copy through a portable HD media?

    Wednesday, June 23, 2010 2:44 PM

Answers

All replies

  • I have a hyper v image, running on my window server 2008 R2 64bit.
    the image is 32bit server contain sql 2008 server.
    after i backup the DB (10GB) and try to install in another server by using Restore in SSMS UI, it prompt me error.
    Error: Specified cast is not valid. (SqlManagerUI)

    May  I know what is the cause of that and how to solve it?

    Does it have something to do with the 64bit / 32 bit different or NTFS / FAT different when copy through a portable HD media?
    Wednesday, June 23, 2010 2:46 PM
  • Hello,

    Try restoring that database from backup using T-SQL.

    Please follow instructions given by Tibor on the following link:

    http://social.msdn.microsoft.com/forums/en-us/sqlsetupandupgrade/thread/071DA5BB-32C5-4C3F-9378-7E67C5DF2D44

    The following link may help also:

    http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/9f29c16b-d783-406e-94f2-22720b8993b4


    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, June 23, 2010 3:07 PM
    Moderator
  • No it is not 64 or 32 bit issue, Instead of using SSMS GUI, try running a Restore Command, issue could be you need to adjust path of your data and log files to match the system on which you are performing a restore...

    --Step 1: Retrive the Logical file name of the database from backup.
    RESTORE FILELISTONLY
    FROM DISK = 'C:\YourBaackUpFile.bak'
    GO

    --Step 2 Restore Database

    Use Master
    Go
    RESTORE DATABASE YourDB
    FROM DISK = 'C:\YourBaackUpFile.bak'
    WITH MOVE 'YourMDFLogicalName' TO 'D:\DataYourMDFFile.mdf',--adjust path
    MOVE 'YourLDFLogicalName' TO 'D:\DataYourLDFFile.mdf'
     

    Wednesday, June 23, 2010 4:21 PM