A restore script that sorts names as text can grab a copy or a log file. Parse the dates first, drop the bad ones, and break ties on purpose.
SQL SERVER – Transaction Log Full – Transaction Log Larger than Data File – Notes from the Field #001
Notes from the Field begins with Tim Radney on a common issue: transaction log full, or a log file larger than the data file, filling your drive.
Rebuilding System Databases With Setup When master Is Lost
Plan rebuilding system databases with Setup when master has no usable backup, then restore logins, jobs, and configuration.
What Is Replication in SQL Server?
Replication in SQL Server copies chosen tables to other servers and keeps them current. Publisher, distributor and subscriber in plain words, the three kinds, and why replication is not high availability or a backup.
Database Security Basics for a Small Business
Database security basics for a small business cover patching, off-site backups, strong logins, limited access, and encryption that works.
Read-Only Filegroups: Locking Away Old Data
Read-only filegroups let you lock old data so nothing can change it by accident. This post moves old rows to their own filegroup, makes it read-only, shows what still works and what fails, and explains how partial backups skip the locked data.
SQL SERVER – Database in RESTORING State for Long Time
Database stuck in restoring state after you restored every backup? Usually the last log was restored without RECOVERY. Here is how to bring it online.