Learn more about SQL Server tools

   
   























Latest from MSSQLTips















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







 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Free T-shirt

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.