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.
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
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.
15 People are following this question.
