Backing Up and Restoring Databases in Microsoft SQL Server 2008 (10154)




This two-hour course provides you with the skills and knowledgerequired to plan and implement a backup strategy in SQL Server 2008. Inthis course, you will explore the different backup types and learn howto use them to formulate a backup strategy that meets yourrequirements. You will also learn how to create different types ofbackups and use the backup compression feature introduced in SQL Server2008.

Topics covered in this course include:

  • Backup Strategies in Microsoft SQL Server 2008
  • Backing Up User Databases
  • Restoring User Databases
  • Implementing Database Snapshots
  • System Databases and Disaster Recovery

Student prerequisites:

To benefit from this course, the learner must be familiar with usingMicrosoft Windows. They must have knowledge of basic relationaldatabase concepts and querying data by using Transact-SQL. They must befamiliar with the role of a database administrator.



  • Understand backup strategies in SQL Server 2008.
  • Describe partial and copy-only backup.
  • Back up user databases.
  • Restore user databases.
  • Implement database snapshots.
  • Recover system databases.


User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-BURD-S208
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend