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
Step 1: Planning your SQL Server backup
Step 2: Developing and testing your SQL Server backup
Step 3: Implementing your SQL Server backup
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.
More information from SearchSQLServer.com
- Tip: Selecting a SQL Server recovery model
- Topic: Research SQL Server backup and recovery best practices
- RSS: Sign up for our RSS feed to receive a daily dose of SQL Server expert advice
This was first published in October 2005