Mass Data Protection & Recovery

I’m back! I had an interesting issue occur today that I thought could help you all out.

When you need to recover data that is synchronized between multiple data stores or database types, you have to make sure (in general) that you recover all the data to the same point in time.

For instance, we have a client who runs a Microsoft SQL server that has data which is in sync with Intuit Quickbooks.  It took a while to figure out why the custom application was failing, but when we narrowed it down to the mismatched data - the client admitted to us that they restored the QB file alone.  The solution was simple - restore both to the same point in time and we were good to go.

The lesson here is to document the recovery requirements from an application and operations perspective, don’t just rely on having all your data backed up.

This entry was posted on Wednesday, October 22nd, 2008 at 11:27 am and is filed under Backup Strategies. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.