Overview
- In this video guide, we will be covering how to migrate WSUS Database (SUSDB) from Windows Internal Database instance to SQL Server instance.
Topics in Video
- 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 - 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
Commands and Notes:
- Connect to WID instance in SQL Management Studio of
sqlcmd - Connect to WID instance in SQL Management Studio of
sqlcmd - 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 and CONTENT_DIR should be changed to for your environment details
Helpful Resources:
sqlcmd Utility – https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017- Migrating the WSUS Database from WID to SQL – https://docs.microsoft.com/en-us/windows-server/administration/windows-server-update-services/manage/wid-to-sql-migration#migrating-the-wsus-database
- Re-index the WSUS 3.0 Database – https://gallery.technet.microsoft.com/scriptcenter/6f8cde49-5c52-4abd-9820-f1d270ddea61
I'm Justin Chalfant! I'm the founder of
I am getting error on postinstall
during post install error Fatal error : the Execute permission was denied on the object “xp_logevent”, database ‘mssqlsystemresource’, schema ‘sys’
Sounds like you don’t have SysAdmin rights in SQL server for where you are trying to install WSUS.
Quick question (I hope). You mention a size limitation on WID but I can find no documentation on it. Do you know what the size limitation is? And where I can find it documented?
524GB I believe so it probably won’t be an issue.
Hey Justin,
So running Get-WindowsFeature -Name UpdateServices* where it is supposed to say ‘SQL Server Connectivity’ I am just getting back ‘Database’.
We are using SQL Server 2012 Standard.
Does that name difference mean anything?
Are you using WID?
Thank you Justin, this is a great video and helped me migrate from WID to SQL DB.
You’re welcome!
Hi.
Thanks for putting this all together 🙂
I have follwed, and the PostInstall task seems to be running for a long time.
Latest in logfile is: Populating Email Notification Status
For how long should it be running ?
Are you all good here.