Call now: (800) 766-1884  


 SQL Server Tips
 SQL Server Training

 SQL Server Consulting
 SQL Server Support
 SQL Server Remote DBA

 SQL Server Scripts
 Scripts Menu




  SQL Server Tips by Robin Schumacher

Reducing Backup and Recovery Impact

SQL Server has always offered online backup capabilities with SQL Server 2005 now offering online restoration. This capability is great because users do not have to be evicted from a database to do a backup. However, backup operations definitely come with an overhead price, so it is important that backups are scheduled during off hours, if possible, to minimize the performance hit of completing a backup. If one assumes that performing backups during off hours is not always an option, is there anything that can be done to lessen the workload impact of performing backups?

There is perhaps no greater responsibility for the database administrator than establishing proper backup and recovery plans. Although the DBA performs other important tasks, nothing approaches the critical nature of ensuring the protection of key corporate data. For this reason, great pains should be taken to ensure that a customized backup and recovery plan is put in place for each critical database. In addition, the master should ensure each customized plan is practiced on development servers to ensure each plan and disaster recovery scenario actually works. Not doing so can lead to ugly surprises if a true failure occurs.

DBAs can work hard at performance tuning and be renowned for optimizing a server, but if they are not practicing good backup strategies, they may likely be found without a job and with a tarnished reputation.

The above book excerpt is from:

High-Performance SQL Server DBA
Tuning & Optimization Secrets

ISBN: 0-9761573-6-5
Robin Schumacher  


Burleson Consulting Remote DB Administration







Burleson is the America's Team

Note: The pages on this site were created as a support and training reference for use by our staff of DBA consultants.  If you find it confusing, please exit this page.

Errata?  SQL Server technology is changing and we strive to update our SQL Server support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:and include the URL for the page.

Burleson Consulting
SQL Server database support


Copyright 1996 -  2013 by Vaaltech Web Services. All rights reserved.

Hit Counter