Deep Dive How to Migrate a WSUS Database from WID to SQL in SCCM
In this video guide, we will be covering how to migrate WSUS Database (SUSDB) from Windows Internal Database instance to SQL Server instance. Accompanying blog post available at https://setupconfigmgr.com/migrating-... #WSUS #SCCM #ConfigMgr
Topics in Video:
Overview of WID limitation and why you want to move to SQL – • Deep Dive How to Migrate a WSUS Database f...
Review WSUS configuration and how to validate if you are using WID for the SUSDB – • Deep Dive How to Migrate a WSUS Database f...
Detach SUSDB from the WID instance – • Deep Dive How to Migrate a WSUS Database f...
Copy WSUS database (SUSDB.mdf and SUSDB_log.ldf) from default WID install path and attach in SQL Instance – • Deep Dive How to Migrate a WSUS Database f...
Run one-time re-indexing in SQL of the SUSDB since it likely was never done in the WID instance – • Deep Dive How to Migrate a WSUS Database f...
Remove the WID Connectivity role service (UpdateServices-WidDB) – • Deep Dive How to Migrate a WSUS Database f...
Install the SQL Server Connectivity role service (UpdateServices-DB) – • Deep Dive How to Migrate a WSUS Database f...
Run WsusUtil postinstall command and reconfigure WSUS to use a SQL Server instead of WID – • Deep Dive How to Migrate a WSUS Database f...
Validate WSUS console loads and shows the exact same data as before the move – • Deep Dive How to Migrate a WSUS Database f...
Validate SCCM software update point sync works from WSUS – • Deep Dive How to Migrate a WSUS Database f...
Commands and Notes:
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
Helpful Resources:
sqlcmd Utility – https://docs.microsoft.com/en-us/sql/...
Migrating the WSUS Database from WID to SQL – https://docs.microsoft.com/en-us/wind...
Re-index the WSUS 3.0 Database – https://gallery.technet.microsoft.com...