Join Martin Guidry for an in-depth discussion in this video Setup, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] In this course I'm going to be performing demonstrations of various backup and restores on Microsoft SQL Server. If you'd like to do the same on your computer, you'll need access to a Microsoft SQL Server. I'm going to be using Microsoft SQL Server 2014 Enterprise Edition. It shouldn't be much of a problem if you would prefer to use Standard Edition or the Business Intelligence Edition. Most of the major editions have very similar features when it comes to backup and restore.
Although it would be ideal for you to use SQL Server 2014, it is possible you could follow along with most things on a previous version of SQL Server like 2012. Not too much has changed with backup and restore from 2012 to 2014. It also may be possible for you to use a future version of SQL server. I can't say for sure what will happen in the future, but it's unlikely Microsoft would make huge changes to the basic backup and restore process.
So the next version of SQL Server will probably have very similar backup and restore features. We'll need a database to backup. For purposes of demonstration, a lot of times it's better to use a fairly small database. It'll just backup and restore much quicker. I'll be using the AdventureWorks2014 database. Realistically you can use almost any database you like. If you would like a copy of AdventureWorks2014, it is available as a free download from Microsoft. Just go over to your favorite search engine and search for AdventureWorks2014.
You'll probably come up with several places to download it. The best one would either be Microsoft.com, MSDN.com, or CodePlex.com
- Types of backups
- Media sets and backups
- Performing a basic backup using the GUI or command line
- Performing a basic restore using the GUI or command line
- Backing up and restoring logs
- Doing partial backup and restores
- Automating backups
- Using encryption and compression