How to properly back up a SQL Server: Step-by-Step Guide

You must have a well-planned and standardized approach to backing up your SQL Servers so you're prepared for the worst-case scenario. Edgewood Solutions' Greg Robidoux offers a three-part guide for putting together a SQL Server backup process -- planning, testing and implementation.

Like any IT project, having a good plan is always the best approach. Here is a guide for the things to consider when putting together a SQL Server backup process for your company. It is broken into planning, development and testing, and implementation. Consider the items as an overall technique to backing up all of your servers. It is always better to have a standard approach instead of doing something different for each of your SQL Servers.

How to properly back up a SQL Server

About the author
Greg Robidoux is the president and founder of Edgewood Solutions LLC, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and has delivered presentations at regional SQL Server users' groups and national SQL Server events.

Next Steps

Selecting a SQL Server recovery model

Research SQL Server backup and recovery best practices

This was last published in October 2005

Dig Deeper on SQL Server Backup and Recovery

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.