Backup^H^H^H^H^H^HRestore best practices

Published Nov 06 2006 11:06 PM 674 Views

There is a lot of emphasis on Exchange database backups. As a result most Exchange administrators plan regular backups with considerations for their specific environment. In the process of developing a backup solution, Exchange administrators have to answer multitude of questions: Shall I protect my databases with daily Full backups, or weekly Full complemented with daily Incrementals? Shall I use VSS technology with hardware clones? Shall I include multiple Storage Groups in a single backup set? How about the IO/CPU impact? Is there enough network bandwidth to complete backups within nightly backup window? Where shall I store backups? How often should I retire the backup media? How do I monitor backups? ...
 
Successful backups are all goodness and a must have, but do you know if your backups are good enough to restore, well at least good enough to bet your job on it?   One of the horror stories I remember hearing from PSS was an Exchange administrator thinking backups were succeeding daily came to realize the good backups were all overwritten by bad ones when excessive database corruptions finally took his database offline. There was no hope of restoring from backups, and repair was not an option either. Granted a good monitoring solution (and an administrator paying attention to monitoring reports) can go a long way, but unlike good wine backups don't get better with age. A restore process that was perfect six months ago can fail to work due to changes on the backup product, changes in configuration, changes in the process, or a simple change of personnel in charge of the restore.
 
Just like you schedule regular backups, you should also schedule regular testing of your restore procedures. I am not asking you to restore all your backups all the time, neither am I telling you to restore some of your backups some of the time, what I am advising is "to restore some of your backups all the time".  When it comes to being prepared for database failures, running weekly or biweekly restores to a Recovery Storage Group is a small step for an administrator but a giant step for your users' precious data.
 
Be prepared with backups, and don't be afraid to use them.

- Ayla Kol

5 Comments
%3CLINGO-SUB%20id%3D%22lingo-sub-600562%22%20slang%3D%22en-US%22%3EBackup%5EH%5EH%5EH%5EH%5EH%5EHRestore%20best%20practices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-600562%22%20slang%3D%22en-US%22%3E%3CP%3E%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22Verdana%22%20size%3D%222%22%3EThere%20is%20a%20lot%20of%20emphasis%20on%20Exchange%20database%20backups.%20As%20a%20result%20most%20Exchange%20administrators%20plan%20regular%20backups%20with%20considerations%20for%20their%20specific%20environment.%20In%20the%20process%20of%20developing%20a%20backup%20solution%2C%20Exchange%20administrators%20have%20to%20answer%20multitude%20of%20questions%3A%20Shall%20I%20protect%20my%20databases%20with%20daily%20Full%20backups%2C%20or%20weekly%20Full%20complemented%20with%20daily%20Incrementals%3F%20Shall%20I%20use%20VSS%20technology%20with%20hardware%20clones%3F%20Shall%20I%20include%20multiple%20Storage%20Groups%20in%20a%20single%20backup%20set%3F%20How%20about%20the%20IO%2FCPU%20impact%3F%20Is%20there%20enough%20network%20bandwidth%20to%20complete%20backups%20within%20nightly%20backup%20window%3F%20Where%20shall%20I%20store%20backups%3F%20How%20often%20should%20I%20retire%20the%20backup%20media%3F%20How%20do%20I%20monitor%20backups%3F%20...%20%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3ESuccessful%20backups%20are%20all%20goodness%20and%20a%20must%20have%2C%20but%20do%20you%20know%20if%20your%20backups%20are%20good%20enough%20to%20restore%2C%20well%20at%20least%20good%20enough%20to%20bet%20your%20job%20on%20it%3F%26nbsp%3B%26nbsp%3B%20One%20of%20the%20horror%20stories%20I%20remember%20hearing%20from%20PSS%20was%20an%20Exchange%20administrator%20thinking%20backups%20were%20succeeding%20daily%20came%20to%20realize%20the%20good%20backups%20were%20all%20overwritten%20by%20bad%20ones%20when%20excessive%20database%20corruptions%20finally%20took%20his%20database%20offline.%20There%20was%20no%20hope%20of%20restoring%20from%20backups%2C%20and%20repair%20was%20not%20an%20option%20either.%20Granted%20a%20good%20monitoring%20solution%20(and%20an%20administrator%20paying%20attention%20to%20monitoring%20reports)%20can%20go%20a%20long%20way%2C%20but%20unlike%20good%20wine%20backups%20don't%20get%20better%20with%20age.%20A%20restore%20process%20that%20was%20perfect%20six%20months%20ago%20can%20fail%20to%20work%20due%20to%20changes%20on%20the%20backup%20product%2C%20changes%20in%20configuration%2C%20changes%20in%20the%20process%2C%20or%20a%20simple%20change%20of%20personnel%20in%20charge%20of%20the%20restore.%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3EJust%20like%20you%20schedule%20regular%20backups%2C%20you%20should%20also%20schedule%20regular%20testing%20of%20your%20restore%20procedures.%20I%20am%20not%20asking%20you%20to%20restore%20all%20your%20backups%20all%20the%20time%2C%20neither%20am%20I%20telling%20you%20to%20restore%20some%20of%20your%20backups%20some%20of%20the%20time%2C%20what%20I%20am%20advising%20is%20%22to%20restore%20some%20of%20your%20backups%20all%20the%20time%22.%26nbsp%3B%20When%20it%20comes%20to%20being%20prepared%20for%20database%20failures%2C%20running%20weekly%20or%20biweekly%20restores%20to%20a%20Recovery%20Storage%20Group%20is%20a%20small%20step%20for%20an%20administrator%20but%20a%20giant%20step%20for%20your%20users'%20precious%20data.%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3EBe%20prepared%20with%20backups%2C%20and%20don't%20be%20afraid%20to%20use%20them.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20face%3D%22Verdana%22%20size%3D%222%22%3E-%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Farchive%2F2006%2F10%2F18%2F429215.aspx%22%20target%3D%22_blank%22%3EAyla%20Kol%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Nov 06 2006 11:06 PM
Updated by: