Share via

SCCM SQL Database Index

Boopathi S 3,951 Reputation points
2021-08-20T20:01:15.027+00:00

Hello,

I am trying to do SCCM database index as per the below procedure
https://stevethompsonmvp.wordpress.com/2016/11/29/optimizing-sccm-databases-revisited/

I have below doubts and please assit

  1. There is a CAS and Primary. Where to start the Indexing? is from CAS Database at the first or In the Primary database
  2. If SCCM Cosole is opened during the database indexing then will it affect any opeartions in the Console
    1. Indexing the database will cause any loss of data in the database
Microsoft Security | Intune | Configuration Manager | Other
0 comments

Answer accepted by question author

Garth 5,806 Reputation points
2021-08-20T22:25:47.603+00:00
  1. You need to index all of them, order doesn't matter.
  2. No it will not affect the indexing
  3. No you will not lose data.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.