MSSQL Express Logfile ist too big

Question

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..

score 4 · Accepted Answer · answered Aug 09 '12 at 22:41

4

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

answered Aug 09 '12 at 22:41

Ben Thul

3,024
17
24

Running 'Exec Sp_Cycle_Errorlog' severall times solved the problem for now. – MemLeak Aug 09 '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 01:57

score 0 · Answer 2 · answered Aug 09 '12 at 22:14

0

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

answered Aug 09 '12 at 22:14

Jim B

24,081
4
36
60

MSSQL Express Logfile ist too big

2 Answers2