question

sudhakar777 avatar image
sudhakar777 asked

How to restore DB Backup from 64 bit SQL Server to 32 bit SQL Server

i have an issue that 64 bit SQL Server DB Backup am unable to restore it into 32 bit SQL Server,for more details, Source Server(Backup Made One) Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor) Destination Server (Restore needs to be done) Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (Intel X86) Feb 25 2011 14:22:23 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 6.0 (Build 6002: Service Pack 2) (VM) Error Facing while restoring ![alt text][1] [1]: /storage/temp/901-restore_fail.jpg Please help me this subject in possible manner, any how i should achieve it.
sql-server-2008sql-server-2008-r2sql-server
restore_fail.jpg (25.9 KiB)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ramesh 1 avatar image
ramesh 1 answered
you dont have Backup compatabilty, you can generate the script with data and execute the script . you can use BCP to export the data between 2 different version servers
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqlmunkee avatar image
sqlmunkee answered
It's not x64 -> x86 that's you're problem. Your source backup is from SQL2008 R2, and your destination is SQL2008. You cannot restore a backup from on server onto a server that is a full release lower.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.