Why can I shrink my Log only if I previously perform a Log-Backup TWICE?
Dear folks, I have a database in FULL recovery mode. Due to an exceptional bulk data load my log-file grew from 25GB to 50GB. I would like to shrink it back to 25GB again, because I need the space for other dbs as well. I wonder why this procedure does **NOT** work: Perform Log-Backup -> Execute "DBCC SHRINKFILE (N'Test1_log' , 25000);" But this **DOES** work: Perform Log-Backup -> Perform Log-Backup (again) -> Execute "DBCC SHRINKFILE (N'Test1_log' , 25000);" Is there a brief explanation for this? Thanks!