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
- Planning your SQL Server backup
- Developing and testing your SQL Server backup
- Implementing you 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.
Selecting a SQL Server recovery model
Research SQL Server backup and recovery best practices