SQL Server Backup Options and Commands tutorial and example

solving sql server problems for millions of dbas and developers since 2006

SQL Product Highlight

SQL Sentry, Inc. - SQL Sentry Performance Advisor

SQL Sentry Performance Advisor for SQL Server delivers an advanced performance dashboard with relevant Windows and SQL Server metrics in a single view along with detailed insight of heavy SQL, blocking, deadlocks, and disk bottlenecks. Performance Advisor is packed with ground-breaking features that are not found in any other performance monitoring software, all designed with the singular goal of simplifying the process of optimizing your SQL Server performance.

Learn more!

Tutorial Menu

Introduction Recovery Models Full Simple Bulk-Logged Backup Types Full Transaction Log Differential File Filegroup Partial Commands BACKUP DATABASE BACKUP LOG Creating Command Line SSMS

SQL Server Backup Options and Commands
(Introduction)

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 to the right or below to scroll through each of these topics.

Sponsor Information

SQL Server having some performance issues? Idera SQL check. FREE SQL Server enhancement.

Get your SQL Server database under version control now! Find out why...

Need SQL Server help and not sure where to turn? Reach out to expert consultants in the USA for a Health Check.

Unlock the power of the Transaction log to discover unauthorized changes and recover lost data

Free SQL Server Learning - Lock Down SQL Server Security