On our SQL server we received an alert that our diskspace was nearly full, after some looking around we have noticed an unusually large log file for the orchestrate database, it is consuming a lot of the storage we have available which will potentially cause issues.
Orchestrate database grows in size after a backup.
Please complete the following steps:-
right-click folder with the database name
select tasks
shrink
files
file type: log
shrink file to: 100 MB, for example.
To prevent the build up in the future it is possible to change the backup methodology. It is possible to change this by doing the following (Note: Please check with your IT company before making this change):
Right click on the database
Select Properties
Choose options
Change the Recovery Model to 'Simple'