Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

test and uat database backups

Posted on 2014-01-08
2
Medium Priority
?
676 Views
Last Modified: 2014-01-08
For each business applicaiton with an underlying database, we seem to have a live production database, a test database (with test clone of the app), and also a user acceptance database for changes/upgrades. our admins only seem to backup the live production db. is this common? Or can there be instances whereby you also backup your test and uat databases as well?
0
Comment
Question by:pma111
2 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39764985
It depends on the shop.  It's all about downtime:  How long can you live without the database until you can rebuild it?

Typically test databases have a known baseline and are recovered/restored back to baseline all the time so there really isn't much of a need to back those up because you have the 'baseline' setup.

Development databases can be in any state at any time.  Also typically not backed up.

This can also vary depending on how you perform change management.  If you have source control and your database changes are in scripts that are part of the source control, then the need to backup development and test is reduced.
0
 
LVL 35

Expert Comment

by:johnsone
ID: 39765165
It definitely depends on the situation.  Most of the places I have been the non-production databases were just copies of production anyway.  There wasn't anything special in them.

If the QA team had a baseline that they needed, we made sure that was in an export file so we could easily put it back to their known good state.  So, special backups of their environments were not necessary as they only care about the known good state.  Plus we did not want to have to do a full restore just for their small set of test data.

If we had an issue with a non-production database, we would just restore production over it.  Takes the same amount of time as restoring a backup of the test database.  Development might lose some structure changes, but with good change management, you just re-apply everything.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question