+ Reply to Thread
Results 1 to 8 of 8
  1. Senior Member itdaddy's Avatar
    Join Date
    Jan 2006
    Posts
    2,056

    Certifications
    A+, MCP, CCNA R/S, CCNA-Security, CCNA Collaboration, CCNP R/S
    #1

    Unhappy HELP!! WsusDBMaintenance.sql where?????

    holy crap...I googled the crap out of this file. where do I get it if my WSUS 3.0 SP1 server doesn't even have this sql script??
    I looked and looked but nothing...Does anyone knowwhere I can get this DB cleanup up script for my WSUS server?
    Thanks help!!!!!!!!
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member
    Join Date
    Apr 2008
    Location
    New York, NY
    Posts
    305

    Certifications
    Life
    #2
    I will take a look at our wsus server for the file. Have you seen this thread on technet on related issue ?

    WSUS 3.0 SP1 database size after update from 2.0
    Reply With Quote Quote  

  4. Senior Member itdaddy's Avatar
    Join Date
    Jan 2006
    Posts
    2,056

    Certifications
    A+, MCP, CCNA R/S, CCNA-Security, CCNA Collaboration, CCNP R/S
    #3
    jbrown that would be great. and if you like i can give you access to my home sftp server and you can upload it there for me.that would be great
    i gooogled the crap out of it. and nothing. Our wsus server cleanup wizard is having issues and Erroring out doesnt ever complete and well I am learning WSuS of my 290 exam as well this is good training..I just love Microsoft products always ready right ouf of the box! and then they ask for 200.00 dollar on top of that to troubleshoot stuff they they can't make right the first. time. I am in the wrong field.hahahah

    but thanks let me know that would be awesome man! I appreciate you help
    or you could cut and paste the code in here and I can copy it and make the file myself huh? that would work as well as long as it is not too big huh? haah thanks
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    Jan 2008
    Posts
    1,941

    Certifications
    MCITP: EA, EMA; MCSE 2000/2003: M; MCSE 2000: S; MCSA 2000/2003: S; MCTS: ISA 2006; VCP3/4
    #4
    http://www.microsoft.com/technet/scr....mspx?mfr=true

    Got it from googling WsusDBMaintenance.sql, clicked first Microsoft link...

    http://technet.microsoft.com/en-us/l.../cc708594.aspx

    Clicked hyperlink WsusDBMaintenance.
    Last edited by HeroPsycho; 04-15-2009 at 06:10 AM.
    Reply With Quote Quote  

  6. Senior Member itdaddy's Avatar
    Join Date
    Jan 2006
    Posts
    2,056

    Certifications
    A+, MCP, CCNA R/S, CCNA-Security, CCNA Collaboration, CCNP R/S
    #5
    did you click on the links? you cannot get the sql file. I got the same links you did but they ive the command line but they do not give the WSUSDBmaintenance.sql file which is the file needed to clean the database. the command line manipualtes the sql file. without thesql file
    i cannot do anything herospcho can you download the sql file did you try??
    I cannot download it it doesnt do anything did you try let me know
    thanks
    I got the same links youd did first try but there has to be files to download not the command line command it is nothing with the prorgram script
    Reply With Quote Quote  

  7. wibble! bertieb's Avatar
    Join Date
    Jun 2007
    Location
    Up and down the UK
    Posts
    1,029

    Certifications
    MCSE:CP&I, SI, MCITPx2, MCSAx2, MCTSx7, VCP6/5/4/3(DCV), EMCISA, Sec+, ITILv3F, legacy MS
    #6
    You'll need to copy and paste the entire sql script into a notepad file and rename it to WSUSDBMaintenance.sql (or similar).

    Then you need to run the sqlcmd string and point it to your script. (One word of caution, cut and paste the sqlcmd string into notepad first as it looks like the -i part contains a special character that you need to replace first - if you cut and paste it directly from the page it's likely it won't run whereas you'l spot it in notepad and can change it to suit.)
    Reply With Quote Quote  

  8. Senior Member itdaddy's Avatar
    Join Date
    Jan 2006
    Posts
    2,056

    Certifications
    A+, MCP, CCNA R/S, CCNA-Security, CCNA Collaboration, CCNP R/S
    #7
    oh my bad herospscho and bertieb

    oh it is on that screen dud i just thought it would download
    maybe that is the script on that site . ithought it was a mock of it.
    so it is the whole script huh? great will try thanks guys
    i just so use to click here and download this or that file.
    i expected that hey thanks
    Reply With Quote Quote  

  9. Senior Member itdaddy's Avatar
    Join Date
    Jan 2006
    Posts
    2,056

    Certifications
    A+, MCP, CCNA R/S, CCNA-Security, CCNA Collaboration, CCNP R/S
    #8
    hey bertieb
    your note on cutting and pasting ahhah I was laughing so hard when I did a google how 100s of people were having that same issue with extra or non existing character transfer thanks man you the man too
    and you to heropschyo excuse me i was gettin a bit pscho there hahah
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks