Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Its on a SBS2008 Server, and we're running out of space. when checking what's the reason i found that the Errorlog from MSSQ is using above 50 gigs (see Picture)

enter image description here

How can i solve this? google doens't show me the right solution..

share|improve this question

2 Answers 2

up vote 4 down vote accepted

Run sp_cycle_errorlog. Schedule that to happen semi-frequently (once a week maybe?).

share|improve this answer
    
Running 'Exec Sp_Cycle_Errorlog' severall times solved the problem for now. –  MemLeak Aug 9 '12 at 22:43
    
@MemLeak: I was thinking more of a SQL Agent job, but whatever stirs your chili. –  Ben Thul Aug 10 '12 at 1:57

Short answer Configure the sql server error logs to keep less log files (management folder) - more details to follow

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.