SQL Server Management Studio: Shrink Database Transaction Logs

Use this article to shrink transaction logs in the Synergize deployment SQL server database to free up or release unused hard disk space.

1. It is recommended to do this process during the business non-peak hours as it may affect the performance. Consult with your DBA or database team before proceeding with this operation.

2. Back up the database and transaction logs before shrinking.

3. Log in to Microsoft SQL Server Management Studio. Expand databases and select Synergize Deployment database (name can vary from one setup to another).

   

4. Right-click on the Deployment Database and select Properties.

   

5. On the Database Properties, select Options and change Recovery model to Simple (if it is not selected) and then click OK.

   

6. Right-click on the Synergize deployment database again and go to Tasks, Shrink, and select Files.

   

7. In the Shrink File window:

   1. Select Log for the File type under the Database files and filegroups section.

   2. Select the Release unused space option under Shrink action.

   3. Click OK.

      

8. This process may take several minutes based on database size.