GeekLab

"c:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLCMD.EXE" -E -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query -Q "BACKUP DATABASE [SUSDB] TO DISK = N'C:\backups\SUSDB.BAK' WITH NOFORMAT, INIT, NAME = N'WSUS Database Backup', SKIP,NOREWIND, NOUNLOAD, STATS = 10"

c:\backups must be writable by the user that is running the database. In my case, I believe this is user "NETWORK SERVICE".… Read more

The virtual machine running my WSUS got a little stuffed. So I decided to move the WSUS data to a fileserver, where the price per MB is a lot lower.

To move:
"C:\Program Files\Update Services\Tools\wsusutil.exe" movecontent [newpath] [logfile]
For example:
"C:\Program Files\Update Services\Tools\wsusutil.exe" movecontent \\fileserver\wsusdata$\ c:\wsusmove.txt

Of course… Read more

WSUS 3 by default stores its metadata in the "Windows Internal Database". 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?

As with a regular SQL Server datastore, you can detach and… Read more

(This article is an update to this original page from march.)

… Read more

In order to keep my users from getting windows update messages, I try to install any client updates at night. I have a few tricks to make this possible:

1: Boot up at night

Most computers can boot up automatically at night, using Wake-On-LAN. If your computer or… Read more

I just described that KB974417 fails to install on a few of my clients. Well, so does KB953297.

Unforunately, I don't have error messages for this update. But I can tell how I fixed it:

The fix

Trying to install NDP1.1sp1-KB953297-X86.exe, I got the message that… Read more

I recently installed a new Microsoft WSUS server. Most of it went just fine. Except for a few… Read more