patternsqlMinor
Reducing Errorlog file size
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
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:
Source: sp_cycle_errorlog (Transact-SQL)
Try the following at least 7 times:
EXEC sp_cycle_errorlog;
GOSource: sp_cycle_errorlog (Transact-SQL)
Code Snippets
EXEC sp_cycle_errorlog;
GOContext
StackExchange Database Administrators Q#24463, answer score: 5
Revisions (0)
No revisions yet.