Backup Log with Truncate_Only
by Brent Ozar
Backup log with truncate_only is a dangerous command with serious consequences. Learn why this might not be the best way to free up drive space on your SQL Server.
Get the Flash Player to see the wordTube Media Player.
In the podcast, we mention a few links:
- SQLServerPedia Wiki article on Backup Log with Truncate_Only by Mike Walsh
- Recovery Models – explains the difference between Full, Simple and Bulk Logged.
- SQL Server Backup & Restore Basics – a tutorial about SQL Server backup options.
- Filegroup Restore Tutorial Video – shows how to back up and restore individual filegroups in a database in SQL Server 2005 and 2008.
- Backup Log with Truncate_Only is Like a Bear Trap – Brent writes about why you should avoid it at all costs.
If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:
- MP4 (Apple) Video Feed
- WMV (Microsoft) Video Feed
- MP3 Audio-Only Feed
- Zune One-Click Subscribe for Video
- Zune One-Click Subscribe for MP3
You can also download this video to watch it later:
