Disk quotas can be overruled by SQL
Posted on 2010-01-12
I have a little problem with my disk quotas.
My quotas (hard) work fine in normal use. When a quota is reached, nothing can be added using the windows explorer.
The problem is with a SQL backup. Users store sometimes a SQL backup on their network shares, this is an allowed company policy.
Now when a user takes a backup in SQL directly to his network share the quota doesn't work, with other words SQL keeps writing data to the share until its finished.
With as result that some users have a quota of 300% and more.
Is there a way to counter this? (without the use of filescreens)
Info: W2k3 R2 x64 with file resource managment role. hard quota's on username.
Thanks for the reply's