HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Reducing Errorlog file size

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
fileerrorlogreducingsize

Problem

We had a user change a password on an account that was on an automation equipment that pinged the sql server many times a second (for no apparent reason - the pinging).

In the end my errorlog ballooned out to >6gb, and my hard drive isn't large enough to accomodate that.

I've cycled it, but it's still at the 6gb.

Is there a way to reduce that?

Thanks

Solution

I am not sure of the exact number, but SQL Server will hang on to the previous 6 errorlog files.

Try the following at least 7 times:

EXEC sp_cycle_errorlog;
GO


Source: sp_cycle_errorlog (Transact-SQL)

Code Snippets

EXEC sp_cycle_errorlog;
GO

Context

StackExchange Database Administrators Q#24463, answer score: 5

Revisions (0)

No revisions yet.