Check file placement for data, logs, and tempdb, inspect volume free space, and plan a Windows file move with a verified recovery path.
Monitoring Log Growth and VLF Counts
Monitor VLF counts and transaction log growth with SQL Server DMVs, then choose file growth settings that keep recovery and maintenance predictable.
SQL SERVER – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup
Error 4214: BACKUP LOG cannot be performed because there is no current database backup. Take one full backup first, and the log backup will work.
SQL SERVER – Rollback TRUNCATE Command in Transaction
Many believe TRUNCATE cannot be rolled back. It can. Here is a Rollback TRUNCATE command example inside a transaction, and why TRUNCATE is logged.
Minimal Logging for Bulk Loads
Minimal logging for Bulk Loads depends on recovery model, table shape, and locking; learn the prerequisites, tradeoffs, and how to verify a load.
SQL SERVER – Find the Size of Database File – Find the Size of Log File
A quick script on sys.master_files to find the size of database file and log file in MB. Remove the WHERE clause to see every database on the server.
CDC Capture Lag: Read sys.dm_cdc_log_scan_sessions
CDC capture lag measures work committed at the source that the capture process has not yet exposed. Compare known markers, scan sessions and captured LSNs, and distinguish capture progress from a downstream consumer reading the changes.