Technical Article

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: )

420 reads

Blogs

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Do Full Backups Break Log Shipping?

By

TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...

Daily Coping 15 Oct 2021

By

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

Read the latest Blogs

Forums

Disabling all access to the server

By Alex John

Hello everyone! We have a small group of users (4) using MS Access 2000...

How to remove data and index fragmentation in a table

By 892717952

The picture is showing the results that I used sp_spaceused for OldTable and NewTable,...

Database Recovery but DB is 7GB and log file is almost 3

By Vector

I have had a server crash and although I was able to recover the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers