Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are using 32-bit versions of SQL Server on 64 Bit machines. We heard that due this version performance can be down. We want to move from 32 Bit to 64 Bit. Which method should we use? Attach/Deattach or Backup/Recovery?

Thanks in advance.

share|improve this question

migrated from Mar 28 '11 at 15:09

This question came from our site for professional and enthusiast programmers.

The database file format is independent of version. You can use either migration method

x64 can be slower under certain conditions: basically bad code. The execution plan cache and some other processes are no longer constrained by the 2GB user mode address space. So you can reduce your buffer pool (data cache) if the plan cache blows up.

Which is caused by bad code such not qualifiying tables, or using sp_OA% all over the place.

share|improve this answer
Or ad-hoc queries that aren't parameterized. – Mark Sowul Mar 28 '11 at 18:17

I would use attach & detach, because you do not want any access to your old database once you've started moving over to the new one. It's also a lot quicker to just detach the file and copy it over, rather than running a backup & restore process, so your downtime due to the upgrade should be shorter.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.