Sdílet prostřednictvím

[Script Of May. 13] How to find the auto growth settings for all the SQL Server databases

  • Článek

image

May.

13

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com//How-to-find-the-auto-e8a46304.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This PowerShell script will demonstrate how to get the auto growth settings of all the databases in a SQL Server instance. If the server name of the SQL Server instance is provided, the script will list the information of all the data files and log files of the databases.

Usually, if we want to get the information of the auto growth settings of all databases in a SQL Server instance, we need open the Properties context of the databases one by one. It will not be a simple task to record all the settings of these databases in your server. An easy way is to run a script to get all this information.

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery

Comments