I am the administrator for a CAD Document Management System running on SQL Server 2000. I am having issues where my DBA group insists it is their policy NOT to let transaction logs grow, and they do not have them backed up and truncated as part of a database maintenance plan.
My system undergoes thousands of transactions per day. My data file is currently over 2GB. The DBA group has set my transaction log max size at 100MB (they just grudgingly increased it from 50MB). As such, I am continually experiencing issues where the system cannot complete transactions because the log file is full.
Yet, since I am not in the DBA group, the refuse to make an exception to their policy. Can anyone point me to any best practices that might offer me some assistance?