A friend sent me only his mdf file instead of a backup of the database. Here is how to attach mdf file without ldf file and let SQL Server build a new log.
A Daily DBA Checklist You Can Run as One Script
Run a daily DBA checklist that reports stale backups, failed jobs, offline databases, recent errors, low volume space and current blocking.
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot
A Snapshot database is a read-only, static view of a source database. I explain how it works and how to restore a database from a snapshot.
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 – Fix : Error : 3117 : The log or differential backup cannot be restored because no files are ready to rollforward
A reader restored a full backup, then hit Error 3117: the log or differential backup cannot be restored. Here is why it happens and what to do.
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.
Backing Up SQL Server Express Without Agent
Backing up SQL Server Express requires a BACKUP script, sqlcmd, Windows Task Scheduler, retention rules, and proof that restores work.