September 17, 2009 at 12:41 am
I am using sql server 2000. yesterday Tlog was not running because log file is out of space issues.
Error is
17052 :
Could not write a CHECKPOINT record in database ID 8 because the log is out of space
resolved this issues as below
1. i am not running truncate and shirnkfile command, To change log file growth to unrestricted mode by 10 percentage and allocate some spaces , because already logfile setting option for file growth restricted 750MB and full recovery mode, now log file size is 759MB that's wts facing this issue
2.To change the full recovery model and take regular tlog backup. now tlog jobs work fine.
suggestion Pls.
Thanks
October 2, 2009 at 2:00 pm
did you resolve this?
---------------------------------------------------------------------
October 8, 2009 at 5:07 pm
you might want to read this: http://www.sqlservercentral.com/articles/64582/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply