To attach a database without log file, run CREATE DATABASE with FOR ATTACH_REBUILD_LOG, or remove the missing log in the SSMS Attach dialog. This tutorial builds a demo database, detaches it, and rebuilds the log on attach. It also explains when the rebuild is impossible and what to check afterward.
Deleting Millions of Rows in Batches Without Filling the Log
Plan deleting millions of rows with bounded commits, an indexed cutoff, log reuse checks, and a clear choice of retention method.
How to Attach MDF Data File Without LDF Log File – Interview Question of the Week #078
Lost or corrupted your log file? Learn how to attach an MDF data file without the LDF log file, using T-SQL or SQL Server Management Studio.
Tail-Log Backup: Saving the Last Transactions Before a Restore
Take a tail-log backup before an approved restore, understand NORECOVERY and damaged-database options, and rehearse the full recovery chain.
SQL SERVER – Huge Transaction Log in Snapshot Replication!
The log kept growing and sys.databases showed REPLICATION as the reuse wait. Here is how I found why the transaction log in snapshot replication was not reused.
SQL SERVER – Huge Transaction Log (LDF) for Database in Availability Group
A reader’s database in an AlwaysOn availability group grew a Huge Transaction Log of 230 GB with error 9002, AVAILABILITY_REPLICA. Here is what to check.
Tracking sp_configure Changes Through Error Log Messages
Someone changed a setting and nobody admits it. Here is what the SQL Server error log keeps, and what it never records.