SQL Server Backups

Series Description

Learn everything you need to know about SQL Server Backups - from basic concepts and practices up to implementation, configuration, and troubleshooting techniques.

Series Details

Total Videos: 15
Total Content Length: 02:45:33

Series Videos

SQL Server Backups Demystified

Watch SQL Server Backups Demystified.

Learn why SQL Server Backups can be hard to understand and master. A must-see video for anyone who isn't familiar with SQL Server Backup functionality.

Covers: Backups, Recovery, Log Files, Transactions, and the SQL Server Storage Engine.

Skill Level: 000 - Overview
Video Length: 11:09

 

Understanding Backup Options

Watch Understanding Backup Options.

Learn about backup types, execution options, storage locations, and other options in order to best address your backup and recovery needs.

Covers: Backups, Recovery, Log Files, Storage Engine, and the SQL Server File System.

Skill Level: 000 - Overview
Video Length: 12:46

 

SQL Server Logging Essentials

Watch SQL Server Logging Essentials.

Take an in-depth look at SQL Server's use of the transaction log and see how write-ahead logging benefits performance, reliability, and data recovery.

Covers: Log Files, Recovery, Backups, the SQL Server Storage Engine, and Transactions.

Skill Level: 000 - Overview
Video Length: 14:15

 

Managing SQL Server 2000 Log Files

Watch Managing SQL Server 2000 Log Files.

Learn how to set database recovery models and properly size and configure file-growth for your SQL Server 2000 databases.

Covers: Log Files, Recovery, Backups, Management, and Enterprise Manager.

Skill Level: 100 - Beginner
Video Length: 10:38

 

Managing SQL Server 2005 & 2008 Log Files

Watch Managing SQL Server 2005 & 2008 Log Files.

Learn how to set database recovery models and properly size and configure file-growth for your SQL Server 2005 and 2008 databases.

Covers: Log Files, Recovery, Backups, Management, and SQL Server Management Studio.

Skill Level: 100 - Beginner
Video Length: 10:28

 

Shrinking SQL Server Log Files

Watch Shrinking SQL Server Log Files.

Learn about the kinds of conditions that make log files adversely grow - and see how to troubleshoot and prevent these problems from blowing your databases out of space.

Covers: Log Files, Transactions, the SQL Server Storage Engine, and Backups.

Skill Level: 300 - Advanced
Video Length: 11:45

 

SQL Server Backup Best Practices

Watch SQL Server Backup Best Practices.

Learn about SQL Server Backup best practices and the role of disaster recovery plans.

Covers: Best Practices, Disaster Recovery, Backups, and Recovery.

Skill Level: 000 - Overview
Video Length: 12:14

 

Backups with Enterprise Manager

Watch Backups with Enterprise Manager.

Learn how to manually backup SQL Server 2000 databases using SQL Server Enterprise Manager.

Covers: Manual Backups, Enterprise Manager, Log File Management.

Skill Level: 100 - Beginner
Video Length: 09:15

 

Backups with SQL Server Management Studio

Watch Backups with SQL Server Management Studio.

Learn the ins and outs of manually executing backups for SQL Server 2005 and 2008 databases using SQL Server Management Studio.

Covers: Manual Backups, SQL Server Management Studio, Log File Management.

Skill Level: 100 - Beginner
Video Length: 09:49

 

Maintenance Plans with Enterprise Manager

Watch Maintenance Plans with Enterprise Manager.

Learn how to create SQL Server Maintenance plans using SQL Server Enterprise Manager.

Covers: Maintenance Plans, Backups, and Enterprise Manager.

Skill Level: 100 - Beginner
Video Length: 10:27

 

Maintenance Plans with Management Studio

Watch Maintenance Plans with Management Studio.

Learn how to create SQL Server 2005 and 2008 Maintenance plans using SQL Server Management Studio.

Covers: Maintenance Plans, Backups, and SQL Server Management Studio.

Skill Level: 100 - Beginner
Video Length: 10:45

 

Troubleshooting SSMS Maintenance Plans

Watch Troubleshooting SSMS Maintenance Plans.

Check out troubleshooting tips and tricks and learn how to troubleshoot problems with your SQL Server 2005 and 2008 Maintenance Plans.

Covers: Backups, Maintenance Plans, and SQL Server Management Studio.

Skill Level: 200 - Intermediate
Video Length: 08:58

 

Troubleshooting SQL 2000 Maintenance Plans

Watch Troubleshooting SQL 2000 Maintenance Plans.

Learn troubleshooting tricks for addressing problems with your SQL Server 2000 maintenance plans.

Covers: Backups, Maintenance Plans, and SQL Server Enterprise Manager.

Skill Level: 200 - Intermediate
Video Length: 07:44

 

Restoring Databases with SQL Server Management Studio

Watch Restoring Databases with SQL Server Management Studio.

Learn how to both test your database backups as part of your disaster recovery plan, as well as how to restore and recover your SQL Server 2005 and 2008 databases in the case of a disaster.

Covers: Backups, Recovery, Recovery Options, and SQL Server Management Studio.

Skill Level: 200 - Intermediate
Video Length: 12:35

 

Restoring SQL Server 2000 Databases

Watch Restoring SQL Server 2000 Databases.

Learn how to use SQL Server Enterprise Manager to test your database backups as part of a disaster recovery and to restore and recover your SQL Server 2000 databases in the case of a disaster.

Covers: Backups, Restore and Recovery, Recovery Options, and SQL Server Enterprise Manager.

Skill Level: 200 - Intermediate
Video Length: 12:45