SqlSetup: which parameter responds to the "Grant perform Volume Maintenance Task ...

[NemoDima]

Tell me please, which parameter in SqlSetup responds to the "Grant perform Volume Maintenance Task privilege to SQL Server Database Engine Service" option?

[johlju]

I don't think there is a parameter for that yet. Is there are argument for setup.exe that corresponds for that setting or is it something that need to be configured after setup.exe has run finished? 🤔

[NemoDima]

There are a few ways:

1. ConfigurationFile.ini :

; Set to "True" to enable instant file initialization for SQL Server service. If enabled, Setup will grant Perform Volume Maintenance Task privilege to the Database Engine Service SID. This may lead to information disclosure as it could allow deleted content to be accessed by an unauthorized principal. 

SQLSVCINSTANTFILEINIT="True"

2. By Local Security Policy: https://medium.com/geopits/enabling-instant-file-initialization-5ba511e38e2b

3. /SQLSVCINSTANTFILEINIT argument: https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-instant-file-initialization

[johlju]

Then it is the argument we should use, it is apparently set to string value True or False

/SQLSVCINSTANTFILEINIT=True

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver15

[SimonBurrowsBD]

Did anything come of this in the end? We're currently trying to replace a scripted SQL install using DBATools with SqlServerDsc and having to find a long way round to set the User Rights Assignment values that the -PerformVolumeMaintenanceTasks switch sets. Would be great to have this as a param on the SqlSetup resource.

[johlju]

There has not been anyone in the community that has sent in a PR for this.