Home Forums SQL Server 2012 SQL Server 2012 - T-SQL ShrinkFile on large database with TRUNCATEONLY RE: ShrinkFile on large database with TRUNCATEONLY
george sibbald
SSC Guru
Points: 104210
More actions
December 30, 2013 at 4:35 pm
#1676502
Yes, that is how you shrink in chunks, though I would go for smaller amounts.
Shrinks do not creatE much log and as your DB is in simple mode it will be truncated anyway
---------------------------------------------------------------------