New Microsoft SQL Server 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! - view details

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.

---

• Source: http://www.learnsqlserver.com
• Category: Disaster Recovery: Backup, Recovery, Clustering, Mirroring, Log Shipping
• Skill Level: 500 (Advanced)
• Length: 18:02 (11.1MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: truncate log, sql truncate, sql log filled up