SQL logs clean up

Question

Hi ,

Coud you help me please how I can properly remove SQL logs, I notices the Log folder size is 191GB

thank you,

Answer 1

Seems like your SQL Server instance produces stack dumps ever so often.

Just remove those *.mdmp files.. Next, install Service Pack2 for SQL Server 2016 and also apply the most recent Cumulative Update. You are way behind on updates, so it is not of interest why get these crashes. Rhey may very have been resolved in later builds.

Would the .mdmp files reappear, it is time to take a closer look.

Answer 2

Open the folder and see where the space is spent. You can always delete as much log files you feel like - but then you may regret if you are asked about the contents. (These are errorlogs, stack dumps, not the transaction log.) So let's first sort out what is hiding there.

But it may be an idea to investigate where they are coming from, so the problem does not reoccur.

By the way, what does "SELECT @@version" retiurn?

Answer 3

Hi, thank you for your help see below there are thousands of files like SQLDumpr****.mdmp

See below what retiurn "SELECT @@version"

Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64) Jul 5 2017 23:41:17 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: ) (Hypervisor)

Answer 4

Hi,

I'm not good with SQL but see below how many logs there almost 2M, is it normal ?

thank you very much.

Answer 5

got it , thank you very much for your help