The filegroup already has the 'AUTOGROW_ALL_FILES' property set.
Another issue is that when you set the AUTOGROW_ALL_FILES or READ_ONLY property to a filegroup, 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.
Straipsnio ID: 3163924 – Paskutinė peržiūra: 2016-07-26 – Peržiūra: 1