WSUS 3.0 Database Maintenance Script

I ran this script because some how my DB has grown to 20GB. The script actually made it grow by another 200MB. How do I reduce the size of my DB?

> On Tuesday, May 29, 2007 1:15 PM DirkDiggle wrote:

> I recently upgraded to WSUS 3.0 and need to run the database maintenance
> script as suggested in the documentation.
>
> Can anyone give me step by step instructions on how to run the script?
>
> I downloaded the script and the sqlcmd utility and attempted to run the
> script but it fails.


>> On Wednesday, May 30, 2007 12:32 AM Ashis wrote:

>> What syntax your are using and what error you got?
>>
>> http://technet2.microsoft.com/window....mspx?mfr=true
>>
>> Ashish
>>
>> http://yashcare.blogspot.com
>>
>>
>>
>>
>> "DirkDiggler" wrote:


>>> On Wednesday, May 30, 2007 7:50 AM DirkDiggle wrote:

>>> I am using this command:
>>>
>>> sqlcmd -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query ???i
>>> c:\WsusDBMaintenance.sql
>>>
>>> I get an unexpected argument error.
>>>
>>>
>>>
>>> "Ashish" wrote:


>>>> On Wednesday, May 30, 2007 11:58 AM Ashis wrote:

>>>> Try This:
>>>>
>>>> Sqlcmd -i WsusDBMaintenance.sql -S
>>>> "np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query"
>>>>
>>>> Make sure wsusdbmaintenace.sql file resides in the same location where
>>>> sqlcmd is placed.
>>>>
>>>> Hope this will work, otherwise let me know. Please confirm if it works.
>>>>
>>>> Regards,
>>>>
>>>> Ashish
>>>>
>>>> http://yashcare.blogspot.com
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> "DirkDiggler" wrote:


>>>>> On Wednesday, May 30, 2007 3:36 PM DirkDiggle wrote:

>>>>> This appears to have worked. Thanks.
>>>>>
>>>>> "Ashish" wrote:


>>>>>> On Wednesday, June 03, 2009 9:10 AM Flo wrote:

>>>>>> You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.


>>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>>>>> Mocking WCF Services Using Moq
>>>>>> http://www.eggheadcafe.com/tutorials...using-moq.aspx