I recently encountered a situation where disk space was almost full, and immediate action was required to free up space. Deleting or relocating critical files was not an option, so shrinking the data ...

Files main Sql-Server-DBA-Toolbox / Disk Space / DBCC SHRINKFILE iteratively.sql DavidSchanzer Update DBCC SHRINKFILE iteratively.sql ...

Title question.<BR>I can't think of any reason why it would lock anything, seems like it's just deallocating space that has been marked as reusuable/not in use anyway, but just in case...do any locks ...

Generate T-SQL commands to shrink all SQL Server user database log files or shrink a single database log file back to the original size or as small as possible ...