This video is from our "SQL Server 2008 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: Chapter Introduction and Setup of the Chapter Examples

  • ·Skill level: 200 (Beginner - Intermediate)
  • ·Run Time: 13:45
  • ·Instructor: Scott Whigham

Description:

Welcome to Chapter 6. In this first video we will go over the key concepts of this chapter relating to Backup and Recovery, as well as setup some of the examples that we will use later in the demonstration videos for this chapter.

Highlights from this video:
  • Chapter overview
  • Why do I need to have backups?
  • The importance of backup and recovery plans and testing these plans
  • Scenario setups
  • Point of Failure and Point in Time recoveries
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)

Chapter 6: SQL Server Backup and Recovery
Chapter Introduction and Setup of the Chapter Examples
2 The Types of SQL Server Backups; Recovery Models
3 The Simple and Full Recovery Models
4 What are Bulk Operations in SQL Server?
5 Transaction Log Architecture and the Bulk Logged Recovery Model
6 How to Change the SQL Server Recovery Model
7 The Basics of Restoring SQL Server Databases
8 Developing Backup Strategies, Part 1
9 Developing Backup Strategies, Part 2
10 Example Restore Scenarios and Crash Procedures
11 How Changing The Recovery Model Affects Backup Strategy
12 Strategies with the FULL Recovery Model
13 How Changing to BULK LOGGED Affects Your Risk
14 A How-to Guide to Performing Bulk Operations
15 How to Take Backups in SQL Server Management Studio (SSMS)
16 How to Take Backups Using Transact-SQL, Part 1
17 How to Take Backups Using Transact-SQL, Part 2
18 Understanding How the Transaction Log Works, Part 1
19 Understanding How the Transaction Log Works, Part 2
20 What Happens When You Don't Backup the Log, Part 1
21 What Happens When You Don't Backup the Log, Part 2
22 Backup Devices
23 Misc Bits: Backup Compression and Security
24 Misc Bits: How to Turn On and View Backup Compression
25 Misc Bits: NO_WAIT, ROLLBACK AFTER, ROLLBACK IMMEDIATE
26 Misc Bits: Emergency! My Transaction Log Has Filled Up!
27 Misc Bits: Taking a Backup of the Log without Clearing It Out
28 Backing Up System Databases and Encryption Keys
29 Where to Look for Problems: Error Logs
30 Where to Look for Problems: Activity Monitor
31 Where to Look for Problems: Default Traces
32 Where to Look for Problems: The Dedicated Administrator Connection
33 Reminders About the Restore Process
34 The Fundamentals of Restoring Databases
35 Performing Point in Time Restores
36 How to Restore a SQL Server Database Using SSMS, Part 1
37 How to Restore a SQL Server Database Using SSMS, Part 2
38 How to Restore a SQL Server Database Using Transact-SQL
39 Disaster Recovery: Restoring Your Entire SQL Server
40 How to Rebuild Your SQL Server (a.k.a. Rebuild Master)
41 How to Restore the Master Database
42 How to Restore SQL Server System Databases, Part 1
43 How to Restore SQL Server System Databases,Part 2
44 How to Perform Use Emergency Mode and DBCC CHECKDB

NOTE: This video is part of our SQL Server 2008 Database Administration course.
This video is from Chapter 6: SQL Server Backup and Recovery

Browse this course's videos now

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.