January 31, 2010 at 11:31 pm
hi to all,
1)Is It possible to install SQL Server 2005 64-bit on windows server 2003 32-bit O.S.Is there any drawbacks?
2)Is It possible to install SQL Server 2005 32-bit on windows server 2003 64-bit O.S.Is there any drawbacks?
2) If i want to migrate sql server 2005 32-bit to 64-bit what are the steps to follow?
🙂
February 1, 2010 at 6:56 am
1. No you can't install a 64-bit application on a 32-bit OS.
2. Yes, you can install 32-bit applications including SQL Server on 64-bit OS. Drawback would be that you can't take advantage of the memory management benefits of 64-bit architecture.
3. I don't know if you can do an in-place upgrade, but to migrate from 32-bit to 64-bit, you can just detach the databases from the 32-bit instance and attach to the 64-bit instance or do backups and restores as the file format is the same between 32-bit and 64-bit. You'd then need to migrate logins and users just like moving from one server/instance to another.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply