25112
asked on
2005 backupfile to be restored into 2012
a)
I am not able to take a sql backup file from
Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86)
and restore to
Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
is the reason because of 32bit vs 64? or version difference or both?
b)
if I had a
2008 R2 SP2 64bit instance available, would I be able to restore that back file there without issues?
I am not able to take a sql backup file from
Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86)
and restore to
Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
is the reason because of 32bit vs 64? or version difference or both?
b)
if I had a
2008 R2 SP2 64bit instance available, would I be able to restore that back file there without issues?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
well, I tried to restore it on 2008R2.. I still get same error
~~~
Specified cast is not valid.
~~~
~~~
Specified cast is not valid.
~~~
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i am doing both backup and restore through GUI. let me try with script and see the results.. will post back.
Provide the error message. I am thinking your database collation could be different and thus, that might be causing your problems when trying to restore.
ASKER
thank you- you were right.. the backup was corrupt the first time. next time worked. thanks a lot!
ASKER
ok.. let me try that..
so the 32/64 does not affect Backup/Restore at all? (64 bit instance backups onto 32 instance and vice versa)