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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 ErrorLogs

Author  Topic 

ggarza75
Yak Posting Veteran

50 Posts

Posted - 2008-09-25 : 08:23:37
Can an ErrorLog get so large that it locks up SQLServer service and cause an "Insufficient Memory" message?

Thanks for the help.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-25 : 08:27:35
quote:
Originally posted by ggarza75

Can an ErrorLog get so large that it locks up SQLServer service and cause an "Insufficient Memory" message?

Thanks for the help.



Not Really. If it is so large, You can sp_cycle_errorlog to minimize it. You can also go to Error log Properties and give time span.
Go to Top of Page
   

- Advertisement -