戻る
-
タイトル
DSP: My SQL Transaction log is getting very big / large -
説明
My transaction log database is getting really large - How do I shrink this? I am using SQL Express and am near the 10GB Limit. -
対策
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 :
- Log into Microsoft SQL Server Management Studio
- Right click on your database.
- Select Properties.
- Click on Options.
- Change the recovery model to Simple.
- Click OK.
- Right click on the database.
- Select Tasks > Shrink > Database.
- Click OK.
- Right click on the database.
- Select Properties.
- Click on Options.
- Change the recovery model to Full.
- 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