Restore 2008.Bak File Error

Question

Hi all,

I just downloaded the database from the client. Which is from 2008 server

Then i restore it on my Local server.

Then i've got this error msg. : Specified cast is not valid. (SQLManagerUI).

Why is it so?

Could anyone tell me what to do with it?
And what shall i do, to restore the DB?

Please help asap.
Thanks


Sphin

Answer 1

the client db is almost 6GB in size, then my local server is sqlserver2008 developer edition.

Thanks in advance

Sphin

Answer 2

Try below:

RESTORE HEADERONLY FROM DISK = '<filename>'
RESTORE FILELISTONLY FROM DISK = '<filename>'

Above should give you enough information to drive the restore command.

---

Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi

Answer 3

I am restoring a 2008 .bak file to a 2008 system.  I have backed up the database twice and gotten the same error as above on restore on 2 different instances of 2008.  It worked on another instance of 2008.  After I do your commands I get the top line says incomplete - and then the filelist has 2 entries.  What isn't clear from your response is what now??

Thanks!

Answer 4

Can you be a bit more detailed? Lets see if I understand you:

You have a backup produced on a 2008 instance.
This backup restores fine into one SQL Server 2008 instrance.
But the backup doesn't restore into the other instance.
On the instane where it doesn't restore, the RESTORE HEADERONLY (or was it RESTORE FILELISTONLY?) returns something "strange". Can you post what "strangeness" it returns.

Also, you can use RESTORE VERIFYONLY to try to find problems in that backup.

---

Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi

Answer 5

Hello Sphin84,

Maybe the Backup Copy you have is corrupted and that is why you are getting this Error.

Do a test, take the backup of any other databse and Restore. if you will be able to do it then for sure your 6GB Backup is corrupted.


Please give a try!!!

Thanks