DSP: My SQL Transaction log is getting very big / large (4309399)

There is a multitude of housekeeping options available within DS Pro such as automatic purging of Sync/Audit logs after X time but in this situation - due to Full recovery mode being the default install option for SQL of Directory Sync Pro and the tool being heavily transaction based. This can occur.

To remediate we recommend a SQL level backup of all your DS Pro databases followed by the following steps :

1. Log into Microsoft SQL Server Management Studio
2. Right click on your database.
3. Select Properties.
4. Click on Options.
5. Change the recovery model to Simple.
6. Click OK.
7. Right click on the database.
8. Select Tasks > Shrink > Database.
9. Click OK.
10. Right click on the database.
11. Select Properties.
12. Click on Options.
13. Change the recovery model to Full.
14. Click OK.

You are free to choose Simple recovery mode of SQL instead of Full but need to be mindful of the implications of such a choice in a DR scenario.

Related Article: DSP: Timeout Error Accessing SQL