Share via


Migrating a WSUS Database from WID to SQL

Overviewin

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

Topics in Video

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: