GeekLab

I recently discovered that one of my most annoying users has found another way to frustrate the WSUS update process: First, she simply didn't shutdown the computer when she went home. Now I've installed a psshutdown script on the SBS Server that forces a shutdown every evening, she found out… Read more

"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

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 recently installed a new Microsoft WSUS server. Most of it went just fine. Except for a few… Read more