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 first published in October 2005

Dig deeper on SQL Server Backup and Recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close