Link to home
Start Free TrialLog in
Avatar of SP_2018 .
SP_2018 .Flag for United States of America

asked on

transaction log file

Can we release the available free space on the transaction log file to disk drive without shrinking the log file.?
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

No.  I mean, as long as the space is still allocated to that log file, it's not free on the drive.  In order to free it for the drive, you have to release it as being reserved (exclusively available) to the log file.
Avatar of SP_2018 .

ASKER

Do you mean performing a shrink operation to release the free space to the disk.?
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial