Solved

SCCM 2012  SMS_WSUS_SYNC_MANAGER Problem

Posted on 2014-01-16
3
1,623 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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 process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now