- Install SQL Server Management Studio 2012 (You can try Management Studio for 2008 or 2008 R2 I recieved an error when I tried initially)
- Run SQL Management Studio 2012 as Administrator
- Connect to Server Name \\.\pipe\Microsoft##WID\tsql\query (old versions used to be \\.\pipe\Microsoft##SSEE\sql\query this has changed in Server 2012 WSUS 4)
- Select Windows Authentication and login
- Expand Databases
- Right Click SUSDB
- Hover over Tasks
- Select Detach (Management Studio for 2008 might give you an error here)
- Select the Drop Connections checkbox
- Click OK
- Move the SUSDB.mdf and the SUSDB_log.ldf to the new location.
- Back in SQL Server Management Studio right click on Databases
- Select Attach
- Click Add
- Navigate to the new SUSDB.mdf location and select the mdf that is in the new location.
- Verify the mdf and the ldf are showing in their location properly.
- Click OK
- Verify the SUSDB database has attached and is not read-only, (if it is listed as SUSDB (Read-Only), verify the permissions on the folder and files you moved are the same as the permissions of its original location).
- Once reattached you should now be good to go. If things look iffy, restart Update Services/IIS Admin/WID Services, or reboot.
http://technet.microsoft.com/en-us/library/hh852349.aspx