Is there a way to force files that are created through a network share, or in a given folder, to be owned by a specific user (i.e., is there a native Windows equivalent of Samba's
Rationale: I have a server that runs a number of SQL Server 2008 instances for our internal development environments. Each instance runs as it's own service user, and each service user has a fixed quota - thus ensuring that if one SQL Server runs away with disk (for whatever reason), it won't keelhaul the server.
However some users need to be able to get backups on and off the server, so I have a number of file shares - one per instance - that point to the appropriate directory. As a result, files get created as the user copying the backup onto the disk, circumventing that instance's disk quota.
At the moment I'm working around it by forcing users to authenticate as the SQL Server service account. This isn't really ideal, but it's the best option I can find at the moment.
So ... is there a way to do this, or can anyone see any other solution that would achieve a similar effect?