November 13, 2007 at 11:33 am
Hi,
I have a issue "how to upgrade 32bit slq2k5 to 64bit version."
This is production live server and i want to upgrade sql server 2005 from 32 bit to 64 bit with out distrabing live data bases.
If any one know the steps regading upgrade please help me.
Thank you.
November 14, 2007 at 2:53 pm
You probably have to buy the new hardware compatible with 64 bit OS, then install 64 bit Windows 2003 server, install 64 bit SQL Server software and move the databases.
Regards,Yelena Varsha
November 15, 2007 at 5:08 am
koteswara kishore K. (11/13/2007)
Hi,I have a issue "how to upgrade 32bit slq2k5 to 64bit version."
This is production live server and i want to upgrade sql server 2005 from 32 bit to 64 bit with out distrabing live data bases.
If any one know the steps regading upgrade please help me.
Thank you.
I assume that you have already hardware x64 (currently standard during purchases). If you installed Win 2003 64 Bit edition that it's piece of cake. You need to set up second SQL 2005 64Bit named instance and move one-by-one. If not than you need to move everything to another hardware and start from OS 64Bit installation.
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
November 15, 2007 at 11:52 pm
If you are migrating from 32bit to 64bit (x86) to (x64).
Install the sql2005 of 64bit on 64bit machines.
The system databases are already installed, but user databases are required.
Move your logins from 32bit to 64 bit.
Use Double Take to replicate the user databases on the second server.
Stop the Double Take and attached the user databases in the same order, the order it is in the 32bit environment.
Stop the SQL Server Services and use Double Take to replicate the entire user databases.
Finally, When you get time to stop for 5 minutes the sql server services on 32bit machine. Stop it and see there is no replication left behind. Stop the Double Take and reove the repset.
Start the services on new 64bit machine. Shut down the first 32bit server. Rename and re-ip the 64bit server as 32bit(name/ip).
Restart the server and services on it. It will work fine. Just tune few parameters of sql server.
November 16, 2007 at 7:04 am
Or if you don;t have an 80K Doubletake license.. Set up your SQL 2005(64 bit), set up your logins etc, Backup your current prod, and restore to the 64bit instance, remap the Db logins, and proceed to test and test some more. Tweak your parameters. Maybe run the app(s) in parallel for a while. Once your comfortable with the performance and functionality, schedule a cutover, take your current prod offline, back up your dbs, restore on the new boxes, apply any changes you made to the DBs, remap logins and repoint your apps to the new environment. If things crap the bed you can always back out and bring your original prd back up. Of course, if you want fly off the seat of your pants, just copy/ move or restore to the new server,remap logins,cut over, and cross your fingers 😉
November 16, 2007 at 7:25 am
Everything that SSC-Enthusiastic plus, if you have 32-bit ODBC apps that run on the server, you will want to dig out the 32-bit ODBC Administrator (odbcad32.exe) from the System32 directory. The Data Sources shortcut on the menu is the 64-bit version and should be renamed as such. Then Add another shortcut for the 32-bit ODBC.
November 30, 2007 at 1:15 pm
Just an extra note
If you are using DBMail with 2K5 you need to apply SP1. There is a known problem with 64bit SQL 2k5 that SP1 fixes.
November 30, 2007 at 5:59 pm
There is no need to purchase any licenses.
Ask for the testing and take only 2 week or less and use it. There is no need to do any purchasing.:)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply