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: Backing Up System Databases and Encryption Keys

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

Description:

In this video tutorial we will walkthrough the process of backing up the other bits and pieces, other than users' databases, something which will be criticial to know should you have to rebuild your server or system. We will also discuss the crucial information you will need to know and documentation you will need to keep in order to do this backup.

Highlights from this video:
  • What you need to have in your documentation plan
  • What else do I need to backup besides my user's database?
  • Disucssing why you need to backup: the master,model,msdb,tempdb databases
  • Backing up your service master key


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
1 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
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.