patternsqlMinor
ALTER DATABASE MODIFY FILEGROUP [myfilegroup] AUTOGROW_ALL_FILES
Viewed 0 times
autogrow_all_filesfilegroupdatabasemyfilegroupaltermodify
Problem
I would like to change all file groups in my database to AutoGrow_all_Files, but only if it is currently AutoGrow_Single_File, like this:
How can I check this database property?
ALTER DATABASE mydatabase MODIFY FILEGROUP [myfilegroup] AUTOGROW_ALL_FILESHow can I check this database property?
Solution
Complementing to both Max and Kenneth's answers ..
I would suggest you to apply SQL Server 2016 CU1 as there is a known bug with
The property isn't preserved after the database or the server restarts. The sys.filegroups viewstill shows that the corresponding column for the property (is_autogrow_all_files and is_read_only) is set to 1. However, it's not actually effective.
Also, its important to note that in SQL Server 2016 you dont need TF 1117 since
I would suggest you to apply SQL Server 2016 CU1 as there is a known bug with
AUTOGROW_ALL_FILES property - The property isn't preserved after the database or the server restarts. The sys.filegroups viewstill shows that the corresponding column for the property (is_autogrow_all_files and is_read_only) is set to 1. However, it's not actually effective.
Also, its important to note that in SQL Server 2016 you dont need TF 1117 since
is_autogrow_all_files is equivalent of TF1117Context
StackExchange Database Administrators Q#146628, answer score: 4
Revisions (0)
No revisions yet.