Moving WSUS WID Database in Windows Server 2012

I can not guarantee this will work for you, but here is what I did when a coworker installed the WSUS database to the wrong drive. This post also assumes you know what you are doing, and are able to use SQL Management Studio 2012.

1. Install SQL Server Management Studio 2012 (You can try Management Studio for 2008 or 2008 R2 I recieved an error when I tried initially)
2. Run SQL Management Studio 2012 as Administrator
3. 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)
4. Select Windows Authentication and login
5. Expand Databases
6. Right Click SUSDB
7. Hover over Tasks
8. Select Detach (Management Studio for 2008 might give you an error here)
9. Select the Drop Connections checkbox
10. Click OK
11. Move the SUSDB.mdf and the SUSDB_log.ldf to the new location.
12. Back in SQL Server Management Studio right click on Databases
13. Select Attach
14. Click Add
15. Navigate to the new SUSDB.mdf location and select the mdf that is in the new location.
16. Verify the mdf and the ldf are showing in their location properly.
17. Click OK
18. 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).
19. 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