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 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
It’s the time of year again where companies do crazy sales on the day after Thanksgiving in the US, and we’re doing the same! All
Happy Fourth of July to all who celebrate! I’m looking forward to a great view Thursday evening looking west along the Skagit Valley with some
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
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…