SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


database restoration error


database restoration error

Author
Message
BLADE-1043594
BLADE-1043594
SSC Eights!
SSC Eights! (820 reputation)SSC Eights! (820 reputation)SSC Eights! (820 reputation)SSC Eights! (820 reputation)SSC Eights! (820 reputation)SSC Eights! (820 reputation)SSC Eights! (820 reputation)SSC Eights! (820 reputation)

Group: General Forum Members
Points: 820 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 (97 views, 86.00 KB)
GilaMonster
GilaMonster
SSC Guru
SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)

Group: General Forum Members
Points: 237571 Visits: 46378
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
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: 3124 Visits: 1761
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
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3004 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
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1306 Visits: 654
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
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14873 Visits: 3905
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. 14 Mar 2017: now over 40,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 (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 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
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14873 Visits: 3905
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. 14 Mar 2017: now over 40,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
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 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