I have two computers with SQL Server Express running on them
System A is a 32 bit system running Sql Server 2008. This SQL Server instance has a database that I wish to copy to system B.
System B is a 64 bit system running Sql Server 2008 R2.
Both systems have management studio running on them. I can't copy with the Copy Database Wizard, because the Express version does not support it. What I tried is I did a backup on system A within Management Studio producing a file. I took the file to system B and tried to do a restore, but I got an access denied error message. I don't think a detach/ copy file/ reattach would work because it's going from a 32 bit Express instance to a 64 bit Express R2 instance on another system. Any ideas on how to do this?