Home Forums SQL Server 2008 SQL Server 2008 Administration Shrining log file not releasing the unused space RE: Shrining log file not releasing the unused space
mahesh.dasoni
SSCommitted
Points: 1653
More actions
October 23, 2012 at 1:02 am
#1551744
1st run a log backup then run Dbcc Shrinkfile(2),
After that again run log backup then run Dbcc shrinkfile(2) again this will shrink log file.There might be active transaction which needs to be backed up before shrinking.