Databases in SQL Server 2008: The Data File and the Transaction Log

This video is part of LearnItFirst’s SQL Server 2008 Database Administration course. More information on this video and course is available here:

http://www.learnitfirst.com/Course157

In this chapter we will take a look at databases in SQL Server 2008. We’ll start off in this video with a great overview of what files the database is made of.

Highlights from this video:

– About files in a database
– Data files
– Transaction log files
– “Write Ahead Logging” in SQL Server
– Demonstration
– Writing transactions in SQL Server
– Demonstration and samples

and much more…