LearnItFirst.com: Free Training Videos: Free SQL Server 2000 Video Tutorial: Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency!

LearnItFirst.com: Free Training Videos

Every time we post a new free training video on any site in the LearnItFirst.com Video Training Network, we'll post it here as well. Add this feed into your RSS newsreader so that you'll be notified for each free video. You'll find videos on SQL Server 2005, Windows 2003, Windows Vista, Exchange Server, .NET, Visual Studio, ASP.NET and much, much more

Saturday, June 10, 2006

Free SQL Server 2000 Video Tutorial: Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency!

Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency! - download

Real-World Scenario - your boss (or client) calls you at 4:54PM on Friday afternoon and says, "All of my people are getting an error working with Application X. Can you check what's going on?" You take a look and, sure enough, your transaction log has taken up the entire disk! Your data file is regular size but your transaction log is HUGE. What do you do? If you answered, "Take a transaction log backup" then you need to watch this video (because the log is full, it will not allow you to take a "traditional" transaction log backup). This video, recorded by resident SQL guru Scott Whigham, presents you with the What-If's, the Why's, and How To's of solving this very problem.