Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


database restoration error


database restoration error

Author
Message
BLADE-1043594
BLADE-1043594
Mr or Mrs. 500
Mr or Mrs. 500 (520 reputation)Mr or Mrs. 500 (520 reputation)Mr or Mrs. 500 (520 reputation)Mr or Mrs. 500 (520 reputation)Mr or Mrs. 500 (520 reputation)Mr or Mrs. 500 (520 reputation)Mr or Mrs. 500 (520 reputation)Mr or Mrs. 500 (520 reputation)

Group: General Forum Members
Points: 520 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+++Cool
Attachments
DB Error.JPG (75 views, 86.00 KB)
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47137 Visits: 44346
Might be a management studio bug. Try restoring using T-SQL?


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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


Mayank Khatri
Mayank Khatri
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1811 Visits: 1692
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.
Megistal
Megistal
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1608 Visits: 2555
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.
Scott Ohar
Scott Ohar
Right there with Babe
Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)

Group: General Forum Members
Points: 714 Visits: 653
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
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3142 Visits: 3815
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 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
buzzhead
buzzhead
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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..
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3142 Visits: 3815
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 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
bharath237
bharath237
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 0
did you get an answer for this ?
I am encountering the same problem.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search