title: The log file for database is full
body: <p>So our SQL Server 2000 is giving me the error, "The log file for database is full. Back up the transaction log for the database to free up some log space."</p>
  
  <p>How do I go about fixing this without deleting the log like some other sites have mentioned?</p>
  
  <p>Additional Info:  Enable AutoGrowth is enabled growing by 10% and is restricted to 40MB.</p>