Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SCCM 2012  SMS_WSUS_SYNC_MANAGER Problem

Posted on 2014-01-16
3
1,732 Views
Last Modified: 2014-01-31
I have a problem with SCCM 2012
I would like to mention that I am new to SCCM
I have a problem with SCCM 2012 WSUS sync. Let me try and explain what exactly happened SCCM 2012 was running on HYPER V machine on windows server 2012 because of space issue Hyper V machine where SCCM was running got paused and we could not re run the machine because there was no space available on physical server.
Then we decided to move the SCCM vhd file to another server since that there was lot of issues with SCCM I managed to resolve most of them but stuck with SCCM WSUS error cant seems to get around my head how to resolve the WSUS error (SMS_WSUS_SYNC_manager error)      
Initially Unser SITE STATUS Software update point was showing critical error status then I removed and re added SUP and WSUS role then critical error status changed to OK in SITE Status but under COMPONENT STATUS I am getting SMS_WSUS_SYNC_MANAGER status as critical hence software library is not showing any updates.
I am attaching the error message from Component status and wsyncmger.log
Help me resolve the issue .
SMS-WSUS-SYNC-MANAGER.txt
wsyncmgr.log.txt
0
Comment
  • 2
3 Comments
 
LVL 20

Expert Comment

by:Marten Rune
ID: 39798502
Youre database is most likely corrupt. The message "Microsoft SQL Server reported SQL message 605, severity 212" leeds me to:  http://technet.microsoft.com/en-us/library/aa258728(v=sql.80).aspx

The first thing you do is a backup. This way you can try the various options you have.

Your number one fix is to simply restore an older backup.
Do you have this. (Yeah problem solved, still read the sqlservercentral article)
If not. You're stuck with no easy fix for a corrupt database.

In all cases, you really should read this: http://www.sqlservercentral.com/articles/Corruption/65804/

The CHECKDB syntax is: DBCC CHECKDB (DatabaseName,REPAIR_FAST)
As an example.

If you don't have a good backup. Then AFTER you backed up your corrupt database. Try the REPAIR options in this order:
REPAIR_FAST
REPAIR_REBUILD
and the dreaded
REPAIR_ALLOW_DATA_LOSS
wich does what it says. It may leave you with a transactionally inconsistent database. But usable though.

Regards Marten
0
 

Accepted Solution

by:
SreenivasreddyRanabothu earned 0 total points
ID: 39811066
Dear Experts,

Issues was resolved.

Issue has arisen when we have moved the virtual machine from one Hyper-V host to another Hyper-V host. Since it was properly booting and was giving some errors as stated, we were caught up in resolving the issues one by one. However, finally one of our friend has suggested to combine the all VHDs created during the snapshot process and try. Surprisingly this trick worked.

Thank you very much for all those who have given a thought to this problem.
0
 

Author Closing Comment

by:SreenivasreddyRanabothu
ID: 39823549
It worked.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question