Wow...its been over a month since I first mentioned I was gonna blog about the upgrade of my MOM 2005 infrastructure servers...Sorry.
I started the upgrade at the SQL Server. I had originally had a Windows 2000 Server running SQL 2000 before I implemented the Notification Solution Accelerator. I upgraded that box to Windows Server 2003 so, it had already been upgraded one. I was able to convince management to authorize a new server for the SQL Server, so I got an Intel E7340 4-way with 16 GB of RAM...so its a 64-bit monster.
I configed the new server with SQL 2005 EE 64-bit. I followed the instructions to move the OnePoint DB to a new server. And I found a few other docs after searching the web about moving to SQL 2005. Problem was, I was going from SQL 2000 32-bit to SQL 2005 64-bit. That was not strictly covered by any of the documents. Most documents said to use the MOM 2005 setup program to install the database on the new server. This won't work on a 64-bit box. You have to run the 64-bit create database command. Once the database was created, detached the old DB from the old server and copied them the new box. I changed the registry entries for database server on the Consolidators and rebooted them. I changed the DTS job for the Data Warehouse job, and......Amazingly, it all worked.
So, I have a monster 64-bit SQL 2005 Server...and two Windows 2000 Consolidators...they are next.
-JFH