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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-10 : 15:21:57
|
| Ranjit writes "If i set the size of the Transaction Log file of a database to say 4MB.Then when the size exceeds MB what happens.1.Does it give a error2.It does not give a error3.it overwrites the existing file and starts from 04.It truncates already commited transaction and overwrites the file.Please answer to this question. It is very urgent. Cause i have a size constraint and the size of the Transaction Log is 100MB. which is too large and always increasing.I want to limit it to say 10 MB and this should be done once and no peson shoulld be required to monitor it.If i set the ile size to 10 MB will it work ??Thanks a lotRanjit" |
|
|
|
|
|
Transaction Log Files