This article includes information about the contents of the update and how to obtain the update. The scripts explained in this post allow you to automate several windows server update services wsus tasks such as synchronization, approvals, cleanups, and. Use either sqlcmd or powershell invoke sqlcmd cmdlet to automate it. I wanted to wipe the entire slate clean, and start again.
Reindex and shrink a wsus database on 2008r2 blogger. Download it directly from us here and unzip the contents. To check the bcp version execute bcp v command and confirm that 14. Wsus download speed to slow since 2012 r2 up to 10 times faster during my poc i need to bring a up to date wsus to my customer dedicated environments with no wan connectivity. Install sql server 2005 client tools only on the wsus server so that you have access to the sql management studio console. The workstation appears to be pulling updates for windows 8. It would be best to stop the wsus service after this step. Download update for windows server update services 3. Download and install sql server 2012 sp1 feature pack.
I recently needed to reset the configuration, metadata, and content of a wsus server. Run wsus cleanup and index script on windows server core. The wsusdbmaintenance script is a tsql script that can be run by sql server administrators to reindex and defragment wsus databases. If you only want to check the fragmentation level, just run the first part of the script. This guide is applicable to wsus installations using the windows internal database. By way of comparison, the download labelled microsoft command line utilities for sql server appears in programs and features as version 11. Microsoft command line utilities 11 for sql server. In order to run a thirdparty wsus script against the windows internal database i downloaded the x64 version of the microsoft command line utilities 14 for sql server, but when i attempt the. You can use the sqlcmd utility you find there to run the sql query. An archive of the codeplex open source hosting site.
Microsoft indicates that performance degradation occurs over time on a windows server update services wsus. For more information about how to download microsoft support files, click the following article number to view the article in the microsoft knowledge base. If you are using windows internal database, you will need to use the sqlcmd utility, which can be downloaded. Download microsoft command line utilities 11 for sql. Microsoft products such as windows server update services wsus 3. For standalone wsus servers, or if you are using an older version of configuration manager, it is recommended that you run the wsus cleanup wizard periodically. The sqlcmd utility allows users to connect to, send transactsql batches from, and output rowset information from sql server instances. Migrating windows server update services from windows server 2008 r2 wsus 3. Microsoft has released an update for windows server update services wsus 3. Download microsoft command line utilities 15 for sql server x64 2. If you are using windows internal database wid for the wsus database, you need to use the sqlcmd utility to use this script with windows internal database, you should run the following command. Wsus bits download at full speed upwards in business. By doing this, you can avoid dealing with relying on a system that has sqlcmd. This article does not document that the command has changed under windows 2012.
There is a nifty way to get the initial girth of downloads synchronized which involves a downloaded tool and a command with switches. Cant remember where i found this one, but i run it once a week on my 2008 r2 wsus server and have it email the results to a slack channel. If you are running wsus from a windows internal database on server 2012 enter the following command sqlcmd i s \\. When trying to connect either via sqlcmd or sql management studio via my logged in windows. Reindex the wsus database under windows 2012 hass it. You may wish to run the wsus server cleanup wizard prior to these step. Wsus utilizes the windows internal database, and not a full blown sql database. The complete guide to microsoft wsus and configuration. Wsus 3 by default stores its metadata in the windows internal database. Download and install the sqlcmd tool on the wsus server. Download the appropriate file by clicking one of the links below, then run the downloaded file to install that package. Every time i set up a fresh wsus i had to wait 3 days after 20 gbyte were downloaded with.
With the release of wsus 3, microsoft switched from msde to windows internal database. Recreating the susdb and wsus content folder for a windows. Invokewsusdbma intenance this script utilizes the wsus api to connect to the susdb database used by wsus and perform maintenance on the database using a tsql script found here. By this point, you will hopefully have recovered a few gig of disk space. Now my sql maintenance script runs to completion without errors.
Wsus 2012 changes for new server installs, you may need to first download and install. However im stuck getting the data from the sql query. How to backup wsus database in windows server 2008 keyongtech 011809. To backup wsus database you just need to complete 4 easy steps. Now normally with microsoft sql, youd simply connect remotely using the sql management studio, and you can if youre using fully blown microsoft sql server with your wsus implementation, however most of us arent. So far i have a separate config file that holds the email details of the server, and i think i have got the wsus reindex working. First off, the environment im operating under runs wsus 3.
In that case, reindex with steps 2 and 3 first, then run. Hi i am trying to write a powershell script that reindexs the wsus database and i am stuck. Whatever the reason, here are the steps for recreating the susdb and the wsus content folder. With wsus you may desire the option to store the updates locally and if so this tip will assist you. To run sql scripts on the wid windows internal database on windows server core, well need to install sqlcmd. The performance of large windows server update services wsus deployments will degrade over time if the wsus database is not maintained properly. In my case, i still had the problem of the wsus database. Connect with sqlcmd to wid database internal database on.
This script contributed by the microsoft wsus team. The service is stopped via the iis manager, as it runs as a web site. Powershell script to reindex wsus db and email results. I finally go tired of cleaning up our wsus servers so i automated this task. These are the steps needed to automate running the script using the sqlcmd utility and windows task scheduler when wid is. Just create a scheduled task and run it once a month. Run the following sql command to detach the wsus database susdb from the windows internal database instance by using the sqlcmd utility. If youre struggling with getting your sccm software update point to sync with wsus, prepare yourself to see what ive done to fix it.
Below is the requirements and functions i found to reindex and shrink the db. You may read the microsft article reindex the wsus database. My wsus server runs server 2016 core edition without a gui so everything must be installed via powershell. If the wsus server cleanup wizard has never been run and the wsus has been in production for a while, the cleanup may time out. Now called the windows internal database, more and more system administrators charged with managing wsus and wss are faced with the challenge of managing these databases. Install this update to resolve issues in windows server update services wsus 3. In this video guide, we will be covering how to migrate wsus database susdb from windows internal database instance to sql server instance. The wsusdbmaintenance script is a tsql script that can be run by sql server administrators to reindex and defragment wsus 3. In this article we are going to show you how to backup wsus database in windows server environment. Install the wsus role on the destination server and run through the windows server update services configuration wizard. Recreating the susdb and wsus content folder for a windows server 2012 based wsus computer. Download microsoft command line utilities 11 for sql server from official microsoft download center.
Here are the three files required to defrag the wsus database and remove obsolete computers and updates. Whats important is the wsus configuration and managing the wsus. According to wikipedia, this is an embedded version of sql express, which ships with win2k8, sharepoint services and wsus so, how move this datastore around. The latest issue is now i couldnt access the windows internal database to run any kind of maintenance script. Stop the iisadmin and update services services in computer management. As with a regular sql server datastore, you can detach and move the database.
1601 1528 852 738 376 944 618 275 1058 1397 917 1111 654 1283 169 159 1564 583 1169 463 108 1464 968 1385 620 374 63 456 1237 468 492