SQL Server Backup Options and Commands Tutorial


By:
Overview

One of your last lines of defense for just about any system is to have a backup in place in case there is a need to recover some or all of your data.  This is also true for SQL Server. 

In this tutorial we will discuss

  • selecting the correct recovery models
  • what backup options are available
  • how to create backups using T-SQL commands and SQL Server Management Studio

If you are new to SQL Server you should review each of these topics, so you are aware of the available options and what steps you will need to take in order to recover your data if ever there is the need.

You can either use the outline on the left or click on the arrows at the top or the bottom of each topic.


Last Update: 2/22/2019




Comments For This Article

















get free sql tips
agree to terms