sql db

Configuration Manager 2309 CM Database SQL Server 2022 Since Migrating the CM Database to a new SQL server one of the MPs randomly going offline with the below error message. We have to rebooting or restarting the SMS_EXECUTIVE service on the server for it to come back online. There is NO...

Hi Guys! I am administering a CAS recovery after a HA SQL cluster failure. The Cluster was dismantled, rebuilt and synced by an DB Admin, but obviously, this broke SCCM. The CAS would not connect pointing to a site recovery to reconnect the CAS to the new HA cluster Listener. Towards the end, I...

Hi, Over the weekend the Tempdb files have doubled in size and as a result that the drive is full now. How do I fix this? Shrink the Temp Database? Before I shrink the size I want to understand why this would happen and what's the best practice to keep it at normal size. Thanks, Bunny

Hi What is the reason that we need to create SPN for the same service account which is used for running the SQL Services? What happens if we run the services with one account and provide database access to another account and create SPN for this account? Will there be any issues if we have...

Hi All, I am very new to SCCM can you please help me understand how SCCM removes old data from the SQL DB. 1. How long is the data retained in SQL database. For example if we disable deletion of any old data from the site maintenance tab how long is the data retained on the SQL server...

Hello, My ConfigManger (version:2010) is configured with a separate SQL server. I recently add the report service point following this KB deploying-sccm-2012-part-12-installing-and-configuring-reporting-services-point the whole process was successfully done but I can't see the reports list...

Dear all, I want to know the best way to handle SCCM database. As my SCCM Database size is approx 50GB now and i am thinking to create a new database and attach it with an existing one so that the previous one size stop growing more. Please let me know if it is possible and how in steps...

I am trying to setup SCCM in a test env. And keep getting an error during the SCCM Server install. The error is related to creation of SQL tables, although it creates some of them. Server OS = 2016 Tech Preview SQL = Microsoft SQL Server Enterprise Evaluation (64-bit) w\Service Pack 3...

Frinds, Can you please help me with the complete procedure to move my SCCM 2012 primary database from local drive to other sanstorage drive on same server.. Appropriate if any one can help with if there any prerequisites or checks before moving the database and procedure to complete success DB...