Home » Minimalist Trading Basics » How Do I Turn on Auto Shrink in Sql Server

How Do I Turn on Auto Shrink in Sql Server

Sarah Jenkins • • 8 min read
How Do I Turn on Auto Shrink in Sql Server

Activating the database auto shrink by using SSMS:Enable database auto shrink using T-SQL:Database >> Reports >> Standard Reports >> Disk Usage.Check free space for the database files:Shrink database file:

How do I know if Autogrowth is enabled?

SSMS, right click your db, go to reports->standard reports->disk usage and look for Autogrow/Autoshrink events . Hopefully you have the correct trace levels set up, if not you might have some issues finding out history.

What is Auto shrink in SQL Server?

Summary. AUTO_SHRINK is a database option in SQL Server. When you enable this option for a database, this database becomes eligible for shrinking by a background task. This background task evaluates all databases which satisfy the criteria for Shrinking and shrink the data or log files.

Sarah Jenkins
Author

Sarah Jenkins

Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.