Upgrade from WSUS 2.0 to WSUS 3.0 SP2

The WSUS 3.0 SP2 installation program will upgrade all WSUS 2.0 settings to WSUS 3.0 SP2. Furthermore, if the installation program finds any SQL Server database other than SQL Server 2005 Service Pack 2 or SQL Server 2008, it will back up the existing database, install Windows® Internal Database, and migrate the database to it. For more information on databases, see Choose the Database Used for WSUS 3.0 SP2

Before upgrading from WSUS 2.0 to WSUS 3.0 SP2

You should make sure that your WSUS 2.0 installation is in good working order before upgrading.

  1. Check for recent errors in the event logs, problems with synchronization between downstream servers and upstream servers, or problems with clients not reporting. Make sure that these issues have been resolved before continuing.
  2. You may want to run DBCC CHECKDB to ensure that the WSUS database is correctly indexed. For more information about CHECKDB, see DBCC CHECKDB (https://go.microsoft.com/fwlink/?LinkId=86948).
  3. Back up the WSUS database.

Upgrading a Remote SQL Server Installation from WSUS 2.0 to WSUS 3.0 SP2

If you have installed WSUS 2.0 on one computer and the SQL Server database on another, you must uninstall WSUS 2.0 from the database server before upgrading to WSUS 3.0 SP2.

> [!NOTE] > Please make sure that your WSUS 2.0 database is not corrupt before upgrading.

To upgrade WSUS 2.0 to WSUS 3.0 SP2 with a remote SQL Server installation

  1. Uninstall WSUS 2.0 from the back-end computer. Do not choose to delete the database.

  2. Install WSUS 3.0 SP2 on the front-end computer.

The WSUS Operations Guide, available at https://go.microsoft.com/fwlink/?LinkId=139838, includes other types of migration documentation, such as migrating from Windows Internal Database to Microsoft SQL Server.

After upgrading

It is a good idea to reindex the database after you upgrade. For more information about reindexing the database, see Appendix I: Database Maintenance in the WSUS Operations Guide.