WSUS 3.0 upgrade path from WSUS2.0SP1 with external SQL2000 DB "Thomas Olsen" <thomas_olsen44[ at ]hotmail.com> 6/15/2007 2:59:14 AM Hi guys I have started looking at the possibility to upgrade our WSUS 2.0SP1 (Build 2.0.0.2620) installation to WSUS 3.0. My current installation is running with a remote SQL 2000 database (running on Windows 2003 Server SP1). I am looking at two different upgrade paths (also because I have several other DBs on my SQL 2000 server; like MOM 2005, HP SIM, Altiris, etc so not sure if an in-place upgrade is even possible): 1. Do an in-place upgrade of my current SQL 2000 server. Is this possible? If so, can I follow these steps after upgrading to SQL 2005: - uninstalling WSUS 2.0 from the SQL server? - Upgrade to WSUS 3.0 2. Install a new SQL 2005 server on new HW - Detach the SUSDB from my SQL 2000 server and attach it to my SQL 2005 server. - Change registry on the FE WSUS server to point to my new SQL 2005 server - Upgrade to WSUS 3.0 Some help would be greatly appreciated. Thanks. /Thomas

Re: WSUS 3.0 upgrade path from WSUS2.0SP1 with external SQL2000 DB "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 6/15/2007 4:08:31 AM "Thomas Olsen" <thomas_olsen44[ at ]hotmail.com> wrote in message news:uOelpkvrHHA.1200[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > I have started looking at the possibility to upgrade our WSUS 2.0SP1 > (Build 2.0.0.2620) installation to WSUS 3.0. > My current installation is running with a remote SQL 2000 database > (running on Windows 2003 Server SP1). > > I am looking at two different upgrade paths (also because I have several > other DBs on my SQL 2000 server; like MOM 2005, HP SIM, Altiris, etc so > not sure if an in-place upgrade is even possible): > 1. Do an in-place upgrade of my current SQL 2000 server. > Is this possible? It's certainly possible, but you'd have to coordinate the requisite "in-place upgrade" activities of every single application database installed in that instance. Your better option is to do a side-by-side installation of SQL 2005 and SQL 2000, and migrate each of those application databases one at a time, in accordance with their documented migration procedures -- starting with WSUS 2.0, since that's your application of immediate interest. > If so, can I follow these steps after upgrading to SQL 2005: > - uninstalling WSUS 2.0 from the SQL server? > - Upgrade to WSUS 3.0 Those are the steps you'd have to follow. See the WSUS Deployment Guide for specific guidance in this scenario. > 2. Install a new SQL 2005 server on new HW > - Detach the SUSDB from my SQL 2000 server and attach it to my SQL 2005 > server. > - Change registry on the FE WSUS server to point to my new SQL 2005 server > - Upgrade to WSUS 3.0 That's another option, and probably a better option than either variant of #1. (Make sure you're installing SQL 2005 =SP1= before migrating the WSUS database.) Also, be sure to shutdown the "Update Services" service on the front-end server before beginning the database detach to ensure the database is fully idle for the detach. -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com .....

Re: WSUS 3.0 upgrade path from WSUS2.0SP1 with external SQL2000 DB "Thomas Olsen" <thomas_olsen44[ at ]hotmail.com> 6/15/2007 5:37:03 AM Hi Lawrence Great information and recommendation. If I get money to buy a new server, I'll probably go for the side-by-side scenario. Thanks a lot. /Thomas "Lawrence Garvin (MVP)" <onsitech[ at ]community.nospam> wrote in message news:uvlGZLwrHHA.4020[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > "Thomas Olsen" <thomas_olsen44[ at ]hotmail.com> wrote in message > news:uOelpkvrHHA.1200[ at ]TK2MSFTNGP04.phx.gbl... > >> I have started looking at the possibility to upgrade our WSUS 2.0SP1 >> (Build 2.0.0.2620) installation to WSUS 3.0. >> My current installation is running with a remote SQL 2000 database >> (running on Windows 2003 Server SP1). >> >> I am looking at two different upgrade paths (also because I have several >> other DBs on my SQL 2000 server; like MOM 2005, HP SIM, Altiris, etc so >> not sure if an in-place upgrade is even possible): > >> 1. Do an in-place upgrade of my current SQL 2000 server. >> Is this possible? > > It's certainly possible, but you'd have to coordinate the requisite > "in-place upgrade" activities of every single application database > installed in that instance. Your better option is to do a side-by-side > installation of SQL 2005 and SQL 2000, and migrate each of those > application databases one at a time, in accordance with their documented > migration procedures -- starting with WSUS 2.0, since that's your > application of immediate interest. > >> If so, can I follow these steps after upgrading to SQL 2005: >> - uninstalling WSUS 2.0 from the SQL server? >> - Upgrade to WSUS 3.0 > > Those are the steps you'd have to follow. See the WSUS Deployment Guide > for specific guidance in this scenario. > > >> 2. Install a new SQL 2005 server on new HW >> - Detach the SUSDB from my SQL 2000 server and attach it to my SQL 2005 >> server. >> - Change registry on the FE WSUS server to point to my new SQL 2005 >> server >> - Upgrade to WSUS 3.0 > > That's another option, and probably a better option than either variant of > #1. > (Make sure you're installing SQL 2005 =SP1= before migrating the WSUS > database.) > Also, be sure to shutdown the "Update Services" service on the front-end > server before beginning the database detach to ensure the database is > fully idle for the detach. > > > -- > Lawrence Garvin, M.S., MCTS, MCP > Independent WSUS Evangelist > MVP-Software Distribution (2005-2007) > https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E > > Everything you need for WSUS is at > http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx > > And, almost everything else is at > http://wsusinfo.onsitechsolutions.com > .... >

Re: WSUS 3.0 upgrade path from WSUS2.0SP1 with external SQL2000 DB "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 6/15/2007 1:01:31 PM "Thomas Olsen" <thomas_olsen44[ at ]hotmail.com> wrote in message news:%23amY28wrHHA.2376[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > Hi Lawrence > > Great information and recommendation. > > If I get money to buy a new server, I'll probably go for the side-by-side > scenario. The side-by-side scenario does not require a new server. You can install SQL Server 2005 on a named instance. Migrate from the SQL Server 2000 default instance to the SQL Server 2005 named instance. Once the migrations are complete, and if you desire to do so, the entire package can be migrated back to a default instance of SQL Server 2005. -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com .....