Migrate WSUS to a new server

Question

Hello everyone,

I have a WSUS running on a Windows server 2012R2 with a WID db, and I wanna move it to a new server running 2019.

How can we move/migrate wsus database (wid) to the new server and connect it? Is this possible?

Thanks regards

Answer 1

Hello

Thank you for your question and reaching out.

Option 1 : Create a replica of the upstream server on the new WSUS server, and then successfully sync. Once finished, change it back. Updates from the Microsoft Update Site could be synced by the new WSUS server. Last but not least, we could direct every client to the new WSUS server.

Option 2 : It is better to build a new Server 2019/2022 then point client to this new WSUS url using GPO.

Option 3: https://social.technet.microsoft.com/wiki/contents/articles/508.how-to-move-wsus-from-one-server-to-another.aspx

--If the reply is helpful, please Upvote and Accept as answer--

Answer 2

Hello

Yes, it is possible to migrate the WSUS database from a Windows Internal Database (WID) on a Windows Server 2012 R2 to a new server running Windows Server 2019. Here are the steps you can follow to migrate the WSUS database from WID to a new server:

1.Stop the IIS and WSUS services on the WSUS server. From PowerShell (elevated), run: Stop-Service IISADMIN and Stop-Service WsusService.

2.Detach SUSDB from the Windows Internal Database. You can do this using SQL Management Studio by right-clicking SUSDB -> Tasks -> click Detach. Check “Drop Existing Connections” and click OK (optional, if active connections exist).

3.Copy the SUSDB files to the new server. Copy SUSDB.mdf and SUSDB_log.ldf from the WID Data Folder (%SystemDrive%\Windows\WID\Data) to the new server.

4.Attach SUSDB to the new server. In SQL Server Management Studio on the new server, under the Instance node, right-click Databases, and then click Attach. In the Attach Databases box, under Databases to attach, click the Add button and locate the SUSDB.mdf file (copied from the WID Folder), and then click OK.

After completing these steps, you should be able to connect to the migrated WSUS database on your new server running Windows Server 2019.

Answer 3

I would recommend option 2 or 3 on my guide instead.

https://www.ajtek.ca/wsus/how-to-migrate-or-upgrade-wsus/

If you really want to move the SQL database itself, the information is above from Wesley