If you are already working with CSS, take ideas from the forums and mailing list is a bad idea. As the options might conflict with each other. You should discuss your issue with CSS directly.
I forget if you can report from a CAS in CM12 (you can in CMCB), but since you are talking to CSS it would be best to discuss this option and work with them to perform it. Garth Jones Chief Architect Configuration Manager/SCCM Reporting<https://www.enhansoft.com/> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Miriyala, Vasu Sent: Wednesday, July 26, 2017 1:00 AM To: mssms@lists.myitforum.com Subject: [mssms] SQL DB Issues - A primary site in CAS environ Hello, SCCM 2012 latest CB environ, with a CAS and few primaries. One of primary has SQL issues where SRPOC and/or Tables aren't functioning well. PSS has been working on to fix SQL, however two weeks spent, two more weeks expected to clean a heavy corrupted table to be cleaned up. SQL DB of old instances not helpful to restore as most of old snapshot observed to have same problem. We have had SQL issues in the past, tried many work arounds, which I assume has corrupted some tables or SPROC or so on... HENCE My question now is, is it possible to install a fresh SQL server instance on primary and get it going, with assumption of restore the site data from CAS, and Inventory, status messages etc. will come back again from clients...instead of waiting for two more week of troubleshooting ? Thanks, Vasu This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
