Shrinking SQL Server Log Files
Description
Need to Shrink your Database Log files? Plenty of tutorials online will show you how to trash your log file while implementing a hack. This video will show you what's really going on with your log files, and will help you troubleshoot the real source of your problems instead of telling you to just use TRUNCATE_ONLY on your log files.
This Video Covers
Log Files, Transactions, the SQL Server Storage Engine, and Backups.
Details
Length: 11:45
Skill Level: 300 - Advanced.
Series: SQL Server Backups
Author: Michael K. Campbell
Applies to SQL Server: 2000, 2005, and 2008.
Tags: Disaster Recovery, Best Practices, Transactions, Administration, and Log Files.
Code Download: 1 KB
Video Resources
Video References, Video Transcript, and Accompanying Source Code.
Related Videos
SQL Server Backups Demystified, Understanding Backup Options, and SQL Server Logging Essentials
Viewer Comments
SQL Server Videos are available free of charge.
But you must agree to the following terms before downloading:
Redistribution is prohibited.
Redistribution via any of the following means is prohibited.
• WebServer/HTTP, FTP,
• YouTube and similar sites,
• BitTorrent,
• CD/DVD, Portable Hard-drive, etc.
I already Agreed to these Terms
Non-registered users must agree to terms upon each new visit to the site.
Registration costs nothing, is painless, and is evil-free™. And SSV will never divulge your personal information to third parties. Ever.
Registered Users
Login Here.
Thanks Michael, that was very helpful to me - it is an area I have found tricky to get my head round completely.
This is very nice video and giving what is causing the log file growth.