Database maintenance

Maintaining SQL Server databases.

A complete guide to SHRINK in SQL Server

How to reduce the size of a SQL Server database file properly: good practice, sizing, an incremental strategy, and automation with dbatools.

Taking backups on an availability group

Taking backups on an availability group

Identify and fix transaction log problems

Why is the transaction log disk full?

SQL Server transaction log backups: why and how

In the FULL recovery model, transaction log backups are indispensable. They limit data loss, allow point-in-time restores, and stop the log from filling the disk.