CODEWITHSUNDEEP
sqlsql-serverperformancecounter
PLui
PLui

Reputation: 765

How to get the "Restricted File Growth" parameter on SQL Server?

When adding a file to a filegroup, you can restrict the file growth by a certain size. Is there a way to either query the DB for it? Or get it through performance counter?

Upvotes: 0

Views: 2268

Answers (1)

Eric J. Price
Eric J. Price

Reputation: 2785

--  Deprecated systable
Select  [Filename],
        Size,
        MaxSize,
        Growth
From    sys.sysfiles

--  Replacement system view
Select  physical_name,
        Size,
        max_size,
        growth
From    sys.database_files

MaxSize is the growth limit.

Upvotes: 1

Related Questions