Add an agent job to truncate the log every 10 minutes
In sqlserver management studio;
Right click on jobs
New job
Then in advanced;
To schedule the job;
-
image-20191120-132102.png
200 KB Download
-
image-20191120-131953.png
70 KB Download
-
image-20191120-131910.png
100 KB Download
-
image-20191120-131815.png
90 KB Download
-
image-20191120-131721.png
70 KB Download
-
image-20191120-131644.png
90 KB Download
-
image-20191120-131605.png
300 KB Download
-
image-20191120-131509.png
300 KB Download
-
image-20191120-130648.png
10 KB Download
-
image-20191120-130544.png
10 KB Download
-
image-20191120-130709.png
60 KB Download
-
image-20191120-131406.png
30 KB Download
-
image-20191120-130522.png
10 KB Download
-
image-20191120-130452.png
10 KB Download
-
image-20191120-130508.png
10 KB Download
-
image-20191120-130406.png
30 KB Download
-
worddavf1155cabce6768fc38cf29526d9fd686.png
20 KB Download
-
worddav990a10d8cfb2aa9ea53096a3347ac94a.png
20 KB Download
-
worddav0fab32829d66045e9c4ebe4417009200.png
30 KB Download
-
worddavad14ddf8659698979b934b6de7ec7e98.png
30 KB Download
-
worddav33dd527f81d552e37cad0cc376439ee7.png
20 KB Download
-
worddav1a4240a317f2cfa3c7e2cfed9bca2ca5.png
50 KB Download
-
worddav951d90935003cc43ef5de686ee939443.png
30 KB Download
-
Add sqlserver agent job to truncate the log every 10 minutes.docx
500 KB Download