Migrate Migrating WSUS SUS Database to another Drive

In Knowledge Base Blog by angeladmin

Stop IIS Admin and Update Services

sqlcmd -S np:.pipeMSSQL$MICROSOFT##SSEEsqlquery
use master
alter database SUSDB set single_user with rollback immediate
go
sp_detach_db SUSDB
go

move the database to new location

Open Sql Express Management and Connect to the Windows Internal Database via below server name

.pipeMSSQL$MICROSOFT##SSEEsqlquery

attach database from new location

Start Services back up.