February 20, 2009 at 9:13 am
I have a cluster active/passive 32 bit sql server 2005 server attached to a SAN that I need to upgrade to a 64 bit cluster. I have an 18 hour window to do this. I was thinking of issues I need to deal with. If anyone sees anything obvious or has done this please feel free to insult me. It has one major SSIS package which is a file based (not in msdb) whcih processes text files stored on one of the SAM drives. Al the mdf and ldf files are on SAN drives
1.Script out all jobs and users
2.Detach db's
3.Blow away the servers
4.Rebuild to 64 bit active/passive cluster
5.Install sql server 2005
6.Attach dbs
7.Script back in users and jobs
??????
February 20, 2009 at 9:36 am
Test your SSIS data loads before doing this because there is no Jet support for x64 SQL Server, so if you have to do any Jet loading, you are going to have problems and usually you have to go through a intermediate SQL Expres x86 install to make it work.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
February 20, 2009 at 9:38 am
Thanks in this case all the ssis does is import text files into sql server table and then archive them
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply