Disk quotas can be overruled by SQL

Posted on 2010-01-12
Medium Priority
Last Modified: 2012-05-08

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
Question by:NR_EIS
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 12

Accepted Solution

Chris M earned 375 total points
ID: 26293306
Disk Quotas work by checking file properties before a file (or files) get written on the disk.
If the file size does not exceed the limit, windows will allow the write.

On the contrary, an SQL backup starts with zero bytes of a file and writes inside the file hence growing it till when the backup completes.

This means that disk quotas definitely will not work here.

I suggest that you setup a different backup server with a backup drive which definitely sets a limit to the size of backups on this drive.

Secondly, ask to modify the company policy as far as database backups are concerned to have the backups only written on these new backup drives either on the same server or another dedicated backup server.

All the best,
Chris Musasizi.
LVL 19

Assisted Solution

Rimvis earned 375 total points
ID: 26293431
Hello NR_EIS,

Backup file is written under permissions of SQL server process, not the user who initiated backup. So disk quatas may not apply in this case.



Author Comment

ID: 26304455
Changing the company policy it is then. And making a file screen with bak extension to be sure
Thanks for the replies

Author Closing Comment

ID: 31676013
No solution possible to limit a sql backup at the hand of a disk quota

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question