Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
 Posted - 2005-02-10 : 12:56:50
|
| Once trans log size reaches max filesize, do oldest transactions "drop off" while newer ones are saved?thx |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2005-02-10 : 13:33:41
|
You get an error if you do not expand it or set automatic expansion |
 |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2005-02-10 : 13:35:10
|
| If you use this setting make sure you backup your transaction logs frequently enough to reduce the size of the log. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2005-02-10 : 15:58:40
|
So what happens if the log file has no free entries?quote:
The transaction log is a circular file i.e. when the end is reached any free entries at the start will be used.This means that all being well the file will stay at a constant size as the current entry cycles round.
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-10 : 16:00:10
|
| An error will occur until the problem has been corrected.Tara |
|
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2005-02-10 : 16:03:13
|
| Could'nt have said it better my self thank you Tara |
|
|
|
|
|
|
what happens when log growth is restricted?