Find All Databases with Less Than 20 Percent Free Space and Grow Them
By Lori Brown | Function , Helpful Scripts , SQL Administration , SQL Maintenance , SQL Server
This is kind of a continuation of one of my previous posts. (https://www.sqlrx.com/find-and-modify-file-growth-settings-for-all-databases/ ) Thousands of databases in a SQL instance can make a DBA’s life a bit challenging. Automation suddenly becomes very important. My new client had been shrinking their databases frequently, mistakenly thinking that doing so was a good thing. I needed to […]
Continue reading