How to detach SUSDB that is "currently in use"
I am setting up ConfigMgr SP1 on Windows Server 2008 and I installed WSUS 3.0 SP1 and the SUSDB resides on the same box with ConfigMgr Database. After the setup, I am trying to follow the SQL best practice to move the Logs to a different drive.
There are plenty posts on the web about how you move a SQL 2005 Database or Log files to a different place or you can search SQL online help:
Here are some of the recommend options:
1) Detach and re attach the Database;
2) Backup the Database and then restore.
But when I tried to detach SUSDB, I get the following error:
"Cannot detach the database 'SUSDB' because it is currently in use"
So who is using SUSDB?
IIS Admin Service
Update Services (Not Windows Update Service!)
You need to stop both service to successfully detach SUSDB!
You know how to do the rest.