Came across a problem when upgrading to WSUS SP1 earlier today. If you’ve moved your WSUS database as per my post your upgrade will fail with the following:
Success MWUSSetup Validating pre-requisites…
Success MWUSSetup Creating database backup…
Success MWUSSetup The SQL server instance is remote. No database backup will be created
Success [...]

Microsoft have recently launched the latest version of BDD, now called “Microsoft Deployment” If you ask me, BDD sounded better but oh well.
If like me you don’t want to create packages for each and every windows update for your deployment image, here’s how you can point the build process at your WSUS server.
Firstly, create the [...]

Due to seemingly non-existant documentation on moving a WSUS 3.0 database to a new server, I figured i’d write up my experience.
Database configuration is all stored in:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\UpdateServices\Server\Setup
The keys you’re interested in are SqlServerName and SqlInstanceIsRemote. Microsoft only officially support Windows authentication, so that’s what i’ll cover here.
You’ll be able to connect the the Windows Internal [...]