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?

ASKER CERTIFIED SOLUTION

Mohammed Khawaja

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

25112

ASKER

>> What you need to do is restore it in SQL 2008 and change compatibility level to 100

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)

25112

ASKER

well, I tried to restore it on 2008R2.. I still get same error
~~~
Specified cast is not valid.
~~~

SOLUTION

DBAduck - Ben Miller

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

25112

ASKER

i am doing both backup and restore through GUI. let me try with script and see the results.. will post back.

Mohammed Khawaja

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.

25112

ASKER

thank you- you were right.. the backup was corrupt the first time. next time worked. thanks a lot!