Log Files in SQL 2000

If autogrow has been enabled, the log file will expand to allow the
transaction records to be written to the log file. If autogrow is not
enabled, errors will be raised once the log file is full.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"RG" wrote in message
news:BEAD722D-ADE3-4E01-909E-3C41634B0EF7atmicrosoftdotcom...
What happens when the max size of the log file less than transaction size?

I have configured transaction log backups to take place every 10 mins.
Corect me if I am wrong, the log file relinquishes space after transaction
log was backed up. What happens if transaction log file runs out of space?
(do the transaction log backups continue... and free up space ?)

Thanks in advance