Technical Article

truncate logs regularly

It is a painful experience for all us administrators to truncate logs regularly. I just created a job to executesp_msforeachdb "use ?; backup log ? with truncate_only ; dbcc shrinkfile(2,5)"on all the servers at frequent intervals. It has saved me a lot of time. hope it helps you too.n.b: I assume that file id 2 […]

You rated this post out of 5. Change rating

2003-04-18

314 reads

Blogs

Friday Flyway Tips–Comparison Options

By

Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights

By

giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Becoming Kristyna Ferris <3

By

Hey folks, fun personal post today. A few weeks ago, I got married! My...

Read the latest Blogs

Forums

Exam Ref DP-300 Administering Microsoft Azure SQL Solutions

By Site Owners

Comments posted to this topic are about the item Exam Ref DP-300 Administering Microsoft...

Love

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Love

Drop or delete a existing partition

By Siten0308

Hello, so I was reading on partitioning a large table, Which i successfully did,...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers