Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Error: Specified cast is not valid. (SqlManagerUI) window server R2

Răspuns Error: Specified cast is not valid. (SqlManagerUI) window server R2

  • Wednesday, June 23, 2010 2:44 PM
     
     
    Sign In to Vote
    0

    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?

     

All Replies

  • Wednesday, June 23, 2010 2:46 PM
     
     
    Sign In to Vote
    0
    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 3:07 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    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 4:21 PM
     
     
    Sign In to Vote
    1

    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'