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.
Database maintenance
SQL Server maintenance procedures: log backups, backups on an availability group, a full transaction log, and shrinking database files.
Taking backups on an availability group
Schedule COPY_ONLY full backups and log backups on every replica of an availability group with Ola Hallengren, clean up with dbatools.
Identify and fix transaction log problems
Transaction log growing or disk full: read log_reuse_wait, find the open transaction, change the recovery model and shrink the file.
SQL Server transaction log backups: why and how
Why a database in the FULL recovery model needs log backups, what VM backups do not replace, and how to restore to a precise point in time.