August 14, 2008 at 7:44 am
Hello Comunity
I have a server with Windows 2003 server X64, and in the moment i work with Sql server 2005 X86.
I want to upgrade my Sql Server 2005 X86 to Sql sever 2005 X64.
i have some dought:
1-Do i must install X64 in another instance? , if Yes, this is convenient to uninstall my X86 version first, of course after backup my database and system database?
2-if isn´t necessary to uninstall X86, on the setup of Sql Server 2005 X64, the same one after running update automaticaly my X86 version ??
What the best practices for doing that?
Many thanks
Luis Santos
August 30, 2008 at 9:15 am
Hello comunity
It´s curious because nobody answer me.
Ok, maybe my questions are obvious, but it´s strange that nobody send me a reply.
i repeat my doughts:
1-It is recommended to uninstall X86 before install X64 ?
2- when the installation setup run , i must have two choice, Upgrade the existing instance or create a new one. what the best practice.
I hope someone finally send me a reply.
Best regards
Luis Santos
August 30, 2008 at 11:50 am
I found this on another forum:
Disclaimer: I have not done this... I am just copying what was posted elsewhere in the hope that it helps. Can you set up a test environment to try it first ??
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
just install SQL Server 64-bit. If the original SQL server is default instance, and you need the new one to be too, then uninstall the old one first
keep all the data .MDF ad .LDF files (uninstall doesn't remove them)
then from the new SQL Server, use
sp_attach_db
on each of the database that you want to attach to the 64 bit server
If you install a second x64 instance on the same server it will have to be a named instance ... this means you will have to adjust all your conection strings ... just add in a full backup of all user and system databases beforehand ...
attach/reattach does not always work and it may fail so some steps must be taken...
Additionally, make sure you save the login's, user's and db roles you had in the 32 bit install so that you don't have to recreate them. Make also sure you perform a full db backup of the initial db using the 32 bit instance before reinstall/uninstall. Once the new instance installed, reattach. If the reattach fails, you will have at least a non corrupted backup that you can also restore. Once the db reattached then run the script to recreate all logins...
August 31, 2008 at 7:31 am
Hello Comunity
Many tahnks for your reply
Luis Santos
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply