shrinking logs: how much data will be reclaimed

This script will show you how much diskspace can be reclaimed by shrinking all the logfiles of userdatabases using a DBCC SHRINKFILE(2) command. Often the spacegain is much smaller then expected. SQL Shrinks logfiles the end of the file until it finds the active part of the logfile. (If the active part of the logfile […]

2005-03-21 (first published: )

418 reads

Blogs

Why I am running for the PASS Board in 2020

By

This blog post lists the reasons why I felt the need to run for...

Blog Refresh – Growing Readers

By

Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes...

Daily Coping 27 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SSIS 2017 stopped running, not status is Pending Execution

By ConnieD

We have 3 sql agent jobs that are running SSIS packages.  Until this past...

cannot find MSOLEDBSQL driver for SSIS 2019 connection manager

By sqlfriend

In the list of connection manager driver, I cannot  find MSOLEDBSQL, There is a...

Lean Coffee

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Lean Coffee

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers