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!
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
(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
We’ve added the ability to purchase a self-service health check using a credit card – no more waiting for a scoping call and then budget
Hello, my name is Paul, and I’m a high-functioning alcoholic. For the last ten years or so, I’ve been an alcoholic. A maintenance drinker –
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…