Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

database restoration error Expand / Collapse
Author
Message
Posted Thursday, April 09, 2009 11:17 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, June 01, 2009 6:06 AM
Points: 518, Visits: 354
Hi,


While restoring a database i am getting an error as

"Specified Cast is not valid (SqlManagerUI)"



Why is this so.Please advice!!!!!!!!

I am attaching a screenshot of error.


+++BLADE+++

  Post Attachments 
DB Error.JPG (73 views, 86.94 KB)
Post #694251
Posted Thursday, April 09, 2009 11:24 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 41,529, Visits: 34,445
Might be a management studio bug. Try restoring using T-SQL?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #694263
Posted Thursday, April 09, 2009 11:25 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 14, 2014 10:10 AM
Points: 1,800, Visits: 1,512
what messge do u get when u run this command on ur backup:
RESTORE VERIFYONLY FROM DISK = 'C;\BlahBlah\urDatabase.bak'

where 'C;\BlahBlah\urDatabase.bak' is location of ur database.

Its nothing to do with the error u posted, but its the 1st step to identify if ur Backup file is valid for retoration or not.
Post #694264
Posted Wednesday, July 08, 2009 1:58 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:35 PM
Points: 1,381, Visits: 2,004
I had the same issue as posted.
This is related to a faulty backup.

I tested it again a good one versus a corrupted copy. Both were check each time with a md5sum. The corrupted one always showed the screenshot error and failed the VERIFYONLY test while the good one not.

If trying to restore the faulty backup through SSMS, it can report it as a tape backup or an invalid media backup and refuse to restore it.

I've not try through t-sql however.

In other words, go get another backup.
Post #749546
Posted Monday, December 21, 2009 8:52 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, March 05, 2014 7:51 AM
Points: 712, Visits: 645
Megistal (7/8/2009)
I had the same issue as posted.
This is related to a faulty backup.

I tested it again a good one versus a corrupted copy. Both were check each time with a md5sum. The corrupted one always showed the screenshot error and failed the VERIFYONLY test while the good one not.

If trying to restore the faulty backup through SSMS, it can report it as a tape backup or an invalid media backup and refuse to restore it.

I've not try through t-sql however.

In other words, go get another backup.



I know this is an old thread but i just ran into this problem, and the backup isnt faulty.

I got the specified cast is not valid trying to restore a 2.5 TB native backup file from data domain (network backup device) using the SSMS, if you build the tsql script it works just fine, just figured i would comment on that


Bleeding Edge - just means alot of sleepless nights
Post #837243
Posted Wednesday, December 23, 2009 4:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:21 AM
Points: 2,797, Visits: 3,079
If this works in a script but the same command fails in SSMS, then I suggest you raise this as a bug with Microsoft.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 25 March 2014: now over 28,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #838448
Posted Tuesday, August 10, 2010 12:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 31, 2010 12:00 PM
Points: 1, Visits: 7
Try to see if any resolution on this. Still getting this error when use ssms to restore, and get backup "created using Microsoft Tape Format version 1.240. SQL Server supports version 1.0." message when use tsql to restore with or without move, filelistonly, etc. The backups are fine, but taken from 2008R2 on Win2k8 server, and try to restore to 2008R2 on Win2k3 server. Any issue possibly?

Thanks for any helps, suggestions..
Post #966926
Posted Wednesday, August 11, 2010 2:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:21 AM
Points: 2,797, Visits: 3,079
I think you need to talk to Microsoft about this.

If your backup gts created using Tape Format 1.240 on one operating system and canot be restored on another, using the same version of SQL Server, then this is by definition a bug.

If you confirm that this is in fact happening, please ensure it gets raised on Connect as a bug.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 25 March 2014: now over 28,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #967225
Posted Thursday, April 26, 2012 11:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 26, 2012 11:08 AM
Points: 1, Visits: 0
did you get an answer for this ?
I am encountering the same problem.
Post #1290953
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse