Video:
How to Increase a Database's Size - Multiple Techniques for Increasing Data File and Transaction Log File Size
Skill
level:
300 (Intermediate)- Run Time:
11:14
- Instructor:
Scott Whigham
Description:
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.
Download
and watch this video
NOTE: You will need the TSCC codec
installed to view video
Scott Whigham
Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive
video training libraries focusing on technical training. Scott is also an experienced
consultant, trainer, and author with more than a decade of hands-on experience working
with SQL Server databases, writing and debugging applications using Visual Studio,
and performance tuning. Scott designed the architecture (websites, class libraries,
and database) for the LearnItFirst.com websites and, most
re...
(Scott's full bio can be found here)
NOTE: This video is part of our
SQL Server 2000 Database Administration course.
This video is from Chapter
4:
Working with SQL Server Databases: Creation, Management and Best Practices
