WSUS DB Maintenance Script Wade Godfrey <wade[ at ]lcsd.logan.k12.ut.us> 5/19/2007 12:16:04 AM Has anyone had any success with the script discussed in Appendix I of the Operations Guide? I've tried it with no success. All I get is "unexpected argument" errors. My DB response seems tremendously slow since updating from v2.0 SP1 and I've been hoping this would help.

Re: WSUS DB Maintenance Script ClaudioG64 <ClaudioG64[ at ]gmail.com> 5/21/2007 2:44:28 PM On May 19, 2:16 am, Wade Godfrey <w...[ at ]lcsd.logan.k12.ut.us> wrote: [Quoted Text] > Has anyone had any success with the script discussed in Appendix I of > the Operations Guide? I've tried it with no success. All I get is > "unexpected argument" errors. My DB response seems tremendously slow > since updating from v2.0 SP1 and I've been hoping this would help. Hello, did'you upgrade from WSUS 2.0+SP1 on MSDE (2000) to WSUS 3.0 on Windows Internal Database or a different mix of products ? And, to be sure, are you using this script ? http://www.microsoft.com/technet/scriptcenter/scripts/sus/server/susvvb01.mspx?mfr=true Ciao, Claudio

Re: WSUS DB Maintenance Script Wade Godfrey <wade[ at ]lcsd.logan.k12.ut.us> 5/21/2007 2:52:09 PM Yes, that is the script I have been trying...with no success :-( ClaudioG64 wrote: [Quoted Text] > On May 19, 2:16 am, Wade Godfrey <w...[ at ]lcsd.logan.k12.ut.us> wrote: >> Has anyone had any success with the script discussed in Appendix I of >> the Operations Guide? I've tried it with no success. All I get is >> "unexpected argument" errors. My DB response seems tremendously slow >> since updating from v2.0 SP1 and I've been hoping this would help. > > Hello, > did'you upgrade from WSUS 2.0+SP1 on MSDE (2000) to WSUS 3.0 on > Windows Internal Database or a different mix of products ? > > And, to be sure, are you using this script ? > http://www.microsoft.com/technet/scriptcenter/scripts/sus/server/susvvb01.mspx?mfr=true > > Ciao, Claudio >

Re: WSUS DB Maintenance Script "Eric" <youngec[ at ]hotmail.com> 5/21/2007 3:00:51 PM Try this: Sqlcmd -i WsusDBMaintenance.sql -S "np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query" "Wade Godfrey" <wade[ at ]lcsd.logan.k12.ut.us> wrote in message news:O406fe7mHHA.5052[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Yes, that is the script I have been trying...with no success :-( > > ClaudioG64 wrote: >> On May 19, 2:16 am, Wade Godfrey <w...[ at ]lcsd.logan.k12.ut.us> wrote: >>> Has anyone had any success with the script discussed in Appendix I of >>> the Operations Guide? I've tried it with no success. All I get is >>> "unexpected argument" errors. My DB response seems tremendously slow >>> since updating from v2.0 SP1 and I've been hoping this would help. >> >> Hello, >> did'you upgrade from WSUS 2.0+SP1 on MSDE (2000) to WSUS 3.0 on >> Windows Internal Database or a different mix of products ? >> >> And, to be sure, are you using this script ? >> http://www.microsoft.com/technet/scriptcenter/scripts/sus/server/susvvb01.mspx?mfr=true >> >> Ciao, Claudio >>

Re: WSUS DB Maintenance Script Wade Godfrey <wade[ at ]lcsd.logan.k12.ut.us> 5/21/2007 9:11:31 PM Thanks! Worked like a charm. Eric wrote: [Quoted Text] > Try this: > Sqlcmd -i WsusDBMaintenance.sql -S > "np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query" > > "Wade Godfrey" <wade[ at ]lcsd.logan.k12.ut.us> wrote in message > news:O406fe7mHHA.5052[ at ]TK2MSFTNGP04.phx.gbl... >> Yes, that is the script I have been trying...with no success :-( >> >> ClaudioG64 wrote: >>> On May 19, 2:16 am, Wade Godfrey <w...[ at ]lcsd.logan.k12.ut.us> wrote: >>>> Has anyone had any success with the script discussed in Appendix I of >>>> the Operations Guide? I've tried it with no success. All I get is >>>> "unexpected argument" errors. My DB response seems tremendously slow >>>> since updating from v2.0 SP1 and I've been hoping this would help. >>> Hello, >>> did'you upgrade from WSUS 2.0+SP1 on MSDE (2000) to WSUS 3.0 on >>> Windows Internal Database or a different mix of products ? >>> >>> And, to be sure, are you using this script ? >>> http://www.microsoft.com/technet/scriptcenter/scripts/sus/server/susvvb01.mspx?mfr=true >>> >>> Ciao, Claudio >>> > >