Move SUSDB on SBS2008

Administrative command prompt:
net stop “update services”
net stop w3svc

Run as admin:
Start > All Programs > Microsoft SQL Server 2005 > SQL server Management Studio Express

Connect to server name: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Databases > SUSDB > Right Click > Detach

Tick the “Drop Connections” and click OK.

Navigate to the SUS database folder on C:\ copy/paste it to the desired location using windows explorer.

Back in SQL server Management Studio Express choose “Add”

Add the database in the new location and click OK, OK.

Delete the old database files from C:\

Source: itblog

timdotexe