Search the Community

I'm in the process of designing an entirely new System Center environment for my company and just have a couple of questions regarding the SQL setup for it. I know that i need a CAS hierarchy in this new setup, as it will be global. Unfortunately i have not built a CAS environment before and I'm a bit unfamiliar with the database that it runs on. My plan is to install the database instances on a clustered SQL environment, however i am just unsure if the CAS database needs to run locally on the CAS itself or not. Also, what type of data is on the CAS database itself? Is it the client data for the entire environment, or just used as a vehicle to replicate primary site data between sites? Just trying to size out the storage requirements for the databases. Any insight is appreciated. Thanks

Greeting everyone, I have been running SCCM 2012 in one of my enviroments since the beginning of December, over the last week things have started to go a bit wrong. Firstly none of the Query and Collection totals changed then, when Monitoring Application/Package deployments I noticed that the figures never changed for systems succeeding, in progress, error or unknown. Googled the problems checked all the relevant files and none of the errors that point you to a solution from Microsoft were there, then I found a blog that suggested I restore the site database. Got approval and carried out this task, documented the procedure and after 2 hours all was well, until today that is 2 days later my SCCM Primary Server is in a worse state than we I started, consensus here is for a rebuild of the site. Anyone have any other suggestions before I trash the site and rebuild SQL and SCCM. Thanks in advance David