Monday, December 14, 2009

SQL Server Tutorial - Databases in SQL Server 2008: The Data Fil e and the Transaction Log

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

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

MSSQL Server 2008 training

This video is part of LearnItFirst's SQL Server 2008 Database Administration training course.

Related Links:

SQL Server  training videos