Release Database Transaction Log File Freespace In SQL Server 2016
1
vote
1
answer
61
views
Good afternoon,
We have 4 node SQL Server configure in HA/DR. Periodically, we purge the old data to free up the space. Recently, after the SQL Job to purge the data was executed, we notice an increase of Freespace in the transaction log file size. Please review the following image. 
Questions:
1. How to release the Freespace without causing any disruption in HA?
2. Do we need to perform the operation to each node in HA/DR?
3. The auto growth is configured as follow: 
4. It is our OLTP (busy) database. Do we need to perform any pre-requisite steps before releasing the Freespace?
5. Does it cause any fragmentation?
Please provide your valuable input to resolve this issue. Let us know if you need any further information. We are using SQL Server 2016 Enterprise edition.
Questions:
1. How to release the Freespace without causing any disruption in HA?
2. Do we need to perform the operation to each node in HA/DR?
3. The auto growth is configured as follow:
4. It is our OLTP (busy) database. Do we need to perform any pre-requisite steps before releasing the Freespace?
5. Does it cause any fragmentation?
Please provide your valuable input to resolve this issue. Let us know if you need any further information. We are using SQL Server 2016 Enterprise edition.
Asked by rushabh138
(13 rep)
Dec 21, 2023, 05:45 PM
Last activity: Dec 21, 2023, 06:08 PM
Last activity: Dec 21, 2023, 06:08 PM