Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy


  SQL Server Tips by Burleson

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  

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks

Hit Counter