How to move WSUS Database to another server and have WSUS pick it up

There are native tools to move the WSUS content to new locations using export and the wsusutil.exe, but I didn't find anything about just relocating a database from serer to server (eg. moving from a 2005 to 2008 SQL instance)

  1. Stop "Update Services"
  2. Copy and mount the database using SQL tools
  3. On the WSUS server, open regedit to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup
  4. Modify SqlServerName to point to the name of the new SQL server.
  5. Start "Update Services"

If you found this document useful, please let me know - drop me a quick email.

Last updated 04/21/2010