Error 4214 stops a log backup because SQL Server has no full backup to build on. It shows up after a switch from Simple to Full recovery, or on a database that never had a full backup. Take one full backup, and the log backup works.
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.
SQL Server for Oracle DBAs: The Vocabulary
SQL Server for Oracle DBAs translates instance, database, schema, tablespace, undo, and redo without pretending the two architectures are identical.
CDC Cleanup and Capture Jobs: Keeping the Log and Change Tables Small
Keep CDC cleanup and capture jobs healthy by checking log reuse, job settings, retention, polling, and a stopped-job alert.