Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SCCM 2012  SMS_WSUS_SYNC_MANAGER Problem

Posted on 2014-01-16
3
Medium Priority
?
2,217 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
[X]
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
  • 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
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…

610 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