Share via

Dirsync Database keeps on Increasing…

  • Article

 

Hi

Have you noticed the Office 365 directory sync database just getting larger and larger… If so try the following to clear the sync runs

1. Open the MIISClient.exe and click the Operations tab.

2. From the Actions menu, select "Clear Runs"

3. On the Clear Runs dialog

a. Uncheck the option "save runs before clearing them"

b. Click to select "Clear runs before: " radio button

c. Select a date that will clear runs starting with the oldest, not trying to clear more than about a week at a time.

IMPORTANT: This is pretty important as this operation will cause the transaction log file to grow temporarily. When trying to clear too many runs all at once, the transaction log file could grow a lot, possibly running out of disk space on the drive hosting the file.

4. Wait for it to finish the clear operation

a. This will be apparent when the list of runs has been modified to remove the runs just cleared.

5. Repeat as necessary

Written by Daniel Kenyon-Smith

Comments

  • Anonymous
    January 01, 2003
    Hello, It's because each run is logged and if there is no process to clean up the run history, then it will continue to grow (for full SQL) or hit the limit for SQL Express (10BG) hence the runs need to be cleared.

  • Anonymous
    July 26, 2012
    Hi Dan, what causes this growth to occur?