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.
||The prizes this month are an Amazon.com voucher worth US$50.00 and a license for SQL Backup Pro 6.4 with one year of support and upgrades. SQL Backup Pro compresses, strengthens and encrypts SQL Server backups. To find out more, visit the Red Gate website.|