SQL Server Logging Essentials
Description
Ever wonder what the log file is really for, and how it really works? This conceptual video highlights how the SQL Server Storage engine takes advantage of write-ahead logging functionality both to ensure data consistency and to optimize system performance. In this video you'll also learn why the log file is so important to data recovery operations and learn about best practices for managing log file sizes and keeping your databases operational.
This Video Covers
Log Files, Recovery, Backups, the SQL Server Storage Engine, and Transactions.
Details
Length: 14:15
Skill Level: 000 - Overview.
Series: SQL Server Backups
Author: Michael K. Campbell
Applies to SQL Server: 2000, 2005, and 2008.
Tags: Concepts, Administration, Storage Engine, Log Files, and Transactions.
Video Resources
Video References, and Video Transcript.
Related Videos
SQL Server Backups Demystified, Understanding Backup Options, and Shrinking SQL Server Log Files
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.
need internal storage of logfile
it is very good
can you please tell me with an example of what do you meant by allocation
Hey.. Nice vedio..Nice work.. Appreciable