October 9, 2009 at 1:20 pm
Hello Group
I have a weird problem in my 2000 box. Actually, this box is in production. I am not able to view the current Log events. When I go to management/SQL Server Logs/Current, its taking long time to open the log and once it opens I dont see anything (0 events in that log). Surprisingly, the size is 998537654Bytes.
Pelase Help me out in this regards. Thanks in advance.
Ali
October 9, 2009 at 5:20 pm
You can try cycling the error log using sp_cycle_errorlog. Then try viewing the SQL Log. Enterprise Manager might be having a hard time opening almost a GB log file.
October 12, 2009 at 10:02 am
If you rarely restart SQL Server, the log grows like crazy. I'd set a job to periodically cycle error logs. However I would also increase the number of logs you keep around to not lose data.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply