locked
Clear WSUS Synchronization Logs RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I have Windows Server 2012 R2 and I am trying to clear the synchronization logs but I have had no luck.  Any ideas?
    Monday, August 15, 2016 4:12 PM

Answers

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Keith7，

    You may refer to the following article:

    https://blogs.technet.microsoft.com/sus/2009/03/04/clearing-the-synchronization-history-in-the-wsus-console/

    Note, in server 2012r2, we may use \\.\pipe\MICROSOFT##WID\tsql\query to connect to the database.

    Microsoft® SQL Server® 2012 Express download link:

    https://www.microsoft.com/en-sg/download/details.aspx?id=29062

    Before you make changes to the database, you should make a backup first!

    Best Regards,

    Anne

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.



    Tuesday, August 16, 2016 1:32 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I am getting the error

    Msg 102, Level 15, State 1, Line 3

    Incorrect syntax near '‘'.

    after I run to following script

    USE SUSDB
    GO
    DELETE FROM tbEventInstance WHERE EventNamespaceID = '2' AND EVENTID IN (‘381’, ‘382’, ‘384’, ‘386’, ‘387’, ‘389’)

    • Edited by Keith_7 Tuesday, August 16, 2016 5:25 PM
    • Marked as answer by Keith_7 Wednesday, August 17, 2016 2:13 PM
    Tuesday, August 16, 2016 5:24 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Keith7,

    It's a spelling mistake with the symbol: ', please cope the following content:

    USE SUSDB
    GO
    DELETE FROM tbEventInstance WHERE EventNamespaceID = '2' AND EVENTID IN ('381', '382', '384', '386', '387', '389')

    And check my screenshot above, ensure they are completely the same.

    In addition, the result in my screenshot "13 rows affected" means 13 sync records are deleted.

    Best Regards,

    Anne

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Wednesday, August 17, 2016 1:48 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Keith7,

    I notice you marked the answer, does this mean it work. If so, it's better that you can mark the detailed steps as answer, so that others can find the most useful information. If the issue still exits, let's do further troubleshoot.

    Best Regards,

    Anne

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Thursday, August 18, 2016 12:55 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes, it worked just fine.  Thanks for your help.
    Thursday, August 18, 2016 3:50 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks Ann, once I got SQL 2012 Management Studio Installed and ran this, all is well.

    Friday, June 1, 2018 4:35 PM