Quick Reminder: How to Shrink Database Files Get link Facebook Twitter Pinterest Email Other Apps February 20, 2017 ALTER DATABASE soapnmteachtest SET RECOVERY SIMPLE GO CHECKPOINT GO DBCC SHRINKFILE(soapnmteach, 1) GO ALTER DATABASE soapnmteachtest SET RECOVERY FULL GO Read more