Wednesday, May 5, 2010

Backup strategy for SQL Server

What’s a good backup strategy for us?
Do we have a DBA in place? Do we have a Remote DBA? How long I could leave without my data? How much data I could lose?
That’s question you need to answer.

You need to think about how much time I have to recover the data. You need to have a procedure for all yours backups, because when it’s time to recover, you don’t have time to think how to do it.
I have experience, but I’m very happy to have in my briefcase the procedure for all my backups and where there are.

My best strategy is to have a cross backup, that’s mean have in 2 locations, the same backup.

No comments: