Query to clear sql server logs over a certain age

Asked Jan 06 '17 at 10:13

Active Jan 06 '17 at 12:07

Viewed 248 times

I would like to write a query to clear any SQL Server logs older than 4 days. This is the folder of the SSMS I'm referring to:

edited Jan 06 '17 at 12:07

3N1GM4

asked Jan 06 '17 at 10:13

C Raghavan

What have you tried already? Have a look at ["How do I ask a good question?"](http://stackoverflow.com/help/how-to-ask) and check whether you think your question fits the format for StackExchange. – 3N1GM4 Jan 06 '17 at 10:31
Well... I wouldn't do it by date since the "Current" error log could span multiple days so why not just recycle aka limit the number of error logs stored and / or limit the max size of the individual error log? – S3S Jan 06 '17 at 14:10

0 Answers0