Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

migrated from stackoverflow.com Mar 28 '11 at 15:09

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

2 Answers

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
1  
Or ad-hoc queries that aren't parameterized. –  Mark Sowul Mar 28 '11 at 18:17
add comment

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
add comment

Your Answer

 
discard

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.