It looks like you're new here. Sign in or register to get started.
Alex, I thought what you wanted to do is have a 64bit prod environment, and a 32bit test environment, and you were asking if you could use a database backup from one and use it on the other. You'd have to install 64bit SQL on prod and 32bit SQL on test, because the 'bitness' is not compatible with each other, the software bitness has to match the OS bitness.
The question would then be: can I use a database backup from my 64bit environment and restore it into my 32bit environment.
The database does not differ between the 32 and 64 bit versions. Moving databases between the versions is not a problem. In fact, we have a mirror running with a 64 bit primary and a 32 bit backup