LearnItFirst.com: Free Training Videos: Free SQL Server 2000 Video Tutorial: How to Increase a Database - Multiple Techniques for Increasing Data File and Transaction Log File Size

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

Wednesday, May 17, 2006

Free SQL Server 2000 Video Tutorial: How to Increase a Database - Multiple Techniques for Increasing Data File and Transaction Log File Size

How to Increase a Database - Multiple Techniques for Increasing Data File and Transaction Log File Size - download

What would happen to your production database(s) right now if the transaction log was 100% full? Would the files automatically grow so that there would be more space available for data or would your users be shut-out until you manually added more space? What if it happened to your data file(s)? This video talks about various ways that you, the DBA, can be proactive in managing your disk files including increasing the data file size, suggestions on using autogrowth, how the files grow and disk space is allocated in SQL Server, and much more.