In this survey, I'm interested in how often you perform a full database backup of your production databases. I'll editorialize the results in a week or two.
Thanks!
Back in 2009 I started posting a summary at the end of the year of what I read during the year and people enjoy it
We’re tremendously excited to be developing a library of AI-focused courses, as well as new courses focused on traditional SQL Server topics, all based on
From now until mid-December we have our lowest prices ever on our signature 158-hour Blackbelt training bundle: US$1,599 for Lifetime access (no expiration) US$899 for
It’s been a while since I wrote one of these, but I’m picking up the series again. This is a question that came in through
Back in 2009 I started posting a summary at the end of the year of what I read during the year and people have been
(Yes, this is for last year!) Back in 2009 I started posting a summary at the end of the year of what I read during
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.
4 thoughts on “Survey: how often do you perform a full backup?”
Once a week.
Details details…
Full backups Daily, tlog every 15 or 30 minutes depending upon customer needs.
Full backups & matching tlogs (just to maintain an obvious timeline) are kept available for several weeks until manual Restore testing has been performed and a known good full backup is verified – only official verified good ones are moved offsite, all others are "recycled."
We suggest customer keep as many around / online as possible "just incase" – you never know when you need to restore to. Several automate the Restore testing, or use log shipping as their testing and maintaining of warm backup.
-Mike
Daily in most of the environments(tlogs depending on the business needs) and Full (once a week) + differentials in environments where we have VLDBs or problems like SAN "overcommitting". The latter is beautiful, by the way. Just put all servers on the same SAN…