Answered by:
SCCM 2012 - SQL Server Express at Secondary Site full

Question
-
Hi,
We deployed some secondary sites running SCCM 2012 using SQL Server Express as its datastore. Everything was OK, but now the SCCM databases at the secondary sites are full because we are hitting the 10 GB hard limit of SQL Server Express.
We did some research and found that the table DrsConflictInfo is the biggest table. Based on the table content it seems we are facing some replication issue. Each row's size is 80 kB in average and the most ocurring situation is "Unique Key Conflict. DRS Deletes conflict row" (this is the ConflictType value from the table).
Does anyone know why this table is growing so much? We did some research but could not find anything helpful.
Thanks,
-George
Answers
-
You should contact Microsoft CSS. This is an unexpected growth in the DB and only they can properly troubleshoot this type of deep rooted issue and make proper and supported requirements while also making the product team aware of any issues they uncover that are fundamental to ConfigMgr and could affect others.
Jason | http://blog.configmgrftw.com
- Proposed as answer by John MarcumModerator Tuesday, April 2, 2013 7:33 PM
- Marked as answer by Robert Marshall - MVPMVP, Moderator Wednesday, April 3, 2013 7:21 PM
All replies
-
You should contact Microsoft CSS. This is an unexpected growth in the DB and only they can properly troubleshoot this type of deep rooted issue and make proper and supported requirements while also making the product team aware of any issues they uncover that are fundamental to ConfigMgr and could affect others.
Jason | http://blog.configmgrftw.com
- Proposed as answer by John MarcumModerator Tuesday, April 2, 2013 7:33 PM
- Marked as answer by Robert Marshall - MVPMVP, Moderator Wednesday, April 3, 2013 7:21 PM
-
I would put a call into CSS for this too, it sounds like a bug that they can help sort out.
Rob Marshall | UK | My Blog | WMUG | File CM12 Feedback | CM12 Docs | CM12 Release Notes