This video is from our "SQL Server 2005 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Video: How SQL Server Logs Errors - The SQL Server Error Log and Configuration

Skill level: 300 (Intermediate)
Run Time: 11:11
Instructor: Scott Whigham

Description:

The SQL Server Error Log Viewer in SQL Server 2000 left quite a bit to be desired but the Error Log Viewer in SQL Server 2005 is far better and easier to work with. This video shows you a few alternatives to viewing your SQL Server configuration and errors as well as tips on configuring the SQL Server error logs so that the important logs will be there when you need them. You'll also learn about the architecture of how SQL Server logs errors so that you can manage your SQL Server most effectively.

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Instructor
Related Videos
Related Courses
Other Videos in this Chapter

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)

Video titleSkill

Part 1 - An Overview of the Default SQL Server Installation	100	Download
Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New Tools with SQL Server 2005	200	Download
Creating Database Diagrams in SQL Server Management Studio	200	Download
Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands	300	Download
Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisites	100	Download

CourseRun TimeSkill Level

153 - SQL Server 2005 Integration Services	200-500	31+ hrs
154 - SQL Server 2005 Reporting Services	200-500	17+ hrs
150 - SQL Server Programming (SQL Server 2005/2000): Transact SQL	200-500	37+ hrs
157 - SQL Server 2008 Database Administration	200-500	45+ hrs
189 - C# Programming with Visual Studio 2005	100-300	30+ hrs

Chapter 7: Architecture: System Databases, System Tables, and SQL Server Internals

1	How SQL Server 2005 Uses the Registry and Changes to the Registry
	How SQL Server Logs Errors - The SQL Server Error Log and Configuration
3	Model Database - An Overview of How to Use It and When to Use It (SQL Server 2005)
4	TempDb Database - An Overview of How it Works and When to Use It
5	How to Change the Master Database's File Locations
6	Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure
7	Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc)
8	Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs
9	Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log
10	Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row?
11	Part 1-A Deeper Look at Pages and Extents Using SQL Internals Viewer
12	Part 2-A Deeper Look at Pages and Extents Using SQL Internals Viewer
13	Part 3-A Deeper Look at Pages and Extents Using SQL Internals Viewer

NOTE: This video is part of our SQL Server 2005 Database Administration course.
This video is from Chapter 7: Architecture: System Databases, System Tables, and SQL Server Internals

Login

Video: How SQL Server Logs Errors - The SQL Server Error Log and Configuration

Description:

Scott Whigham