Link to home
Create AccountLog in
Avatar of yourikh
yourikh

asked on

WSUS truncate table

we have a problem with WSUS taking so much space. I did a search on the net and found the way to move it to another drive. However, in the process it prompted that susdb is too large and that the move is failed. Now we need to truncate the susdb. Is there nayone who could be able to let us know how to accomplish this. What would be the commands to execute on osql. We don't have SQL enterprise since we have sbs 2003 standard.
Avatar of Don S.
Don S.
Flag of United States of America image

At this point, in my experience, you would be much better off just uninstalling WSUS completely and then installing WSUS 3.0 SP1 on to the drive you want.  I know redoing all the approvals is a PIA but it has always been a bigger problem in the long run trying to muck around with and then fix WSUS.
Avatar of yourikh
yourikh

ASKER

how would I uninstall and reinstall wsus on sbs 2003. The only step I took to setup wsus was to click on syncronize now and I got myself into a mess. Thanks for the help!
ASKER CERTIFIED SOLUTION
Avatar of Don S.
Don S.
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer