Migrating a WSUS Database from WID to SQL

- In this video guide, we will be covering how to migrate WSUS Database (SUSDB) from Windows Internal Database instance to SQL Server
stance.

Overview of WID limitation and why you want to move to SQL - https://youtu.be/Ms-5lzF9538?t=24
Review WSUS configuration and how to validate if you are using WID for the SUSDB - https://youtu.be/Ms-5lzF9538?t=67
Detach SUSDB from the WID instance - https://youtu.be/Ms-5lzF9538?t=187
Copy WSUS database (SUSDB.mdf and SUSDB_log.ldf) from default WID install path and attach in SQL Instance - https://youtu.be/Ms-5lzF9538?t=355
Run one-time re-indexing in SQL of the SUSDB since it likely was never done in the WID instance - https://youtu.be/Ms-5lzF9538?t=458
Remove the WID Connectivity role service (UpdateServices-WidDB) - https://youtu.be/Ms-5lzF9538?t=603
Install the SQL Server Connectivity role service (UpdateServices-DB) - https://youtu.be/Ms-5lzF9538?t=627
Run WsusUtil postinstall command and reconfigure WSUS to use a SQL Server instead of WID - https://youtu.be/Ms-5lzF9538?t=658
Validate WSUS console loads and shows the exact same data as before the move - https://youtu.be/Ms-5lzF9538?t=898
Validate SCCM software update point sync works from WSUS - https://youtu.be/Ms-5lzF9538?t=908

Connect to WID instance in SQL Management Studio of sqlcmd (Server 2012 or Newer): \\.\pipe\MICROSOFT##WID\tsql\query
Connect to WID instance in SQL Management Studio of sqlcmd (Server 2008 R2 or Older): \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
Powershell command to see WSUS installed role services: Get-WindowsFeature -Name UpdateServices*
Powershell command to remove WSUS WidDB: Remove-WindowsFeature -Name UpdateServices-WidDB
Powershell command to install WSUS SQL Database Connectivity: Install-WindowsFeature -Name UpdateServices-DB
WsusUtil command: WsusUtil.exe postinstall SQL_INSTANCE_NAME="SCUP.CONTOSO.LOCAL" CONTENT_DIR="J:\WSUS"
- SQL_INSTANCE_NAME and CONTENT_DIR should be changed to for your environment details

Additional resources