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

Error when restoring Expand / Collapse
Author
Message
Posted Saturday, October 6, 2012 2:08 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 1:52 AM
Points: 64, Visits: 206
Error when restoring: Object cannot be cast from DBNull to other types. (mscorlib)
Post #1369397
Posted Saturday, October 6, 2012 1:48 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:36 PM
Points: 35,531, Visits: 32,114
Eskandari (10/6/2012)
Error when restoring: Object cannot be cast from DBNull to other types. (mscorlib)


Does the login you're using during the restore have "SA" privs or not?

If the answer is "no", then try that first.

If the answer is "yes", then either the backup media is bad or your backup was from a corrupt database to begin with.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1369459
Posted Sunday, October 7, 2012 1:55 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 1:52 AM
Points: 64, Visits: 206
I Connect using sa
And I have 5 bak files. all of these files are restored before.
Because of a hardware error I change VGA and RAM then install windows 7 and sql server 2008 r2 64 bit edition.
then i try to restore my data base from any of these backups and I see error.
Post #1369504
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse