John Marshall - Customer Fulfilment Manager
John is our customer fulfilment manager and oversees the needs of our clients.
Sep 2007
06
When Auto_Shrink is set to ON, the database files are candidates for periodic shrinking. Both data file and log files can be shrunk automatically by SQL Server. AUTO_SHRINK reduces the size of the transaction log only if the database is set to SIMPLE recovery model or if the log is backed up.
When set to OFF, database files are not automatically shrunk during periodic checks for unused space.
