As DBAs, one of our biggest responsibilities is to protect our data with backups. So, for this month’s question, “What’s your backup strategy?”, please share with us how your approach your backup process. For example, do you take full backups daily and trasaction log backups hourly? Or do you perform full backups weekly, differential backups daily, and transaction log backups every 30 minutes. Tell us what you do, and how you decided on the process you have. Post your responses to the SQL Server Question of the Month in the comments section below (at www.bradmcgehee.com if you are viewing this from a syndicated newsfeed). And don’t forget to enter your e-mail address when you post your response, so I can contact you if you win.

Because there is no right or wrong answer, this month’s winner will be selected randomly from all the entries that are received.