I am routinely taking a BAK file and restoring it. As a result of this action, an MDF file is generated from it by MSSQL.
My problem is that after the detaching the database I need to be able to move the MDF file programmatically and the user that is going to do this needs to not be in the Administrators group or to be the Default SQL server account. Is it possible to configure MSSQL server to that when it creates an MDF file such as this the permissions of the file include a group of my own arbitrary choosing?
It seems logical that this an MSSQL server setting somewhere, that there is a list of permissions that get added to files when they are created but I am having a great deal of trouble getting Google to distinguish between this case and other similar but unrelated cases.