Tag Archives for " Filegrowth "

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

Find and Modify File Growth Settings for All Databases

By Lori Brown | Helpful Scripts , SQL Administration , SQL Server

I have a client who is challenging me in a lot of ways.  They have over a thousand databases in one of their 2 SQL instances.  Over. A. Thousand.  Admittedly, the databases are not big but the sheer quantity of them is daunting to say the least.  To make it more fun, some of the […]

Continue reading