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 |
|
Metcalf
Yak Posting Veteran
52 Posts |
 Posted - 2009-06-04 : 13:35:54
|
| I happened to be browsing the directory where our ERP data is stored, and noticed the LOG file had not been updated in over a month.The log file is 1GB to the DB which is 6GB; both are set to grow by 10%, though the log file is limited to 2GB in size. Is there anything I can do to get the log file, well, logging again? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-06-04 : 13:58:39
|
| this is normally just an artifact of the windows display. The updated date is not changed, until all the changes are "committed", if you will. This will only happen, when you restart the service.Naturally, you should not restart the service just to get this date to update. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-04 : 15:14:01
|
Are you telling about the date of logfile?Do you know there is a physical size of log on disk that is not all in use (same behavior like swapfile of OS)?Maybe there is no reason to grow at this time because your recovery model is set to simple?Don't be angry if I am wrong...GreetingsWebfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Metcalf
Yak Posting Veteran
52 Posts |
Posted - 2009-06-04 : 15:35:22
|
| Ah, that makes sense - all the log files in the same directory have the same last modified date, which IIRC was about the last time the server was rebooted. Thank you for your help, it is much appreciated. |
|
|
|
|
|
|
SQL Transaction log no longer updating?