SQL Backup and Restore Archives - Page 51 of 51 - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

Home

Gouache painting of a rebuilt sage green birdhouse beside an open box of neatly cut matching pieces with one red door piece

Restore Database Backup Using T-SQL, Step by Step

February 25, 2007

Pinal Dave

SQL Tips and Tricks

SQL Backup and Restore, SQL Error Messages, SQL Scripts

To restore database backup files safely, read the backup first, then restore under a name and paths you choose. This post builds a small demo database, backs it up, and restores it with MOVE and REPLACE. It also explains the errors that stop most restores.

A barrel marked LOG overflowing with paper, and a person hesitating at the tap.

SQL SERVER – Shrinking Truncate Log File – Log Full

December 30, 2006

Pinal Dave

SQL Performance

SQL Backup and Restore, SQL Scripts, Transaction Log

The old code I used to truncate log file space with DBCC SHRINKFILE and BACKUP LOG WITH TRUNCATE_ONLY. It breaks the log chain, so take a full backup after.