Interview Questions
1. What is the Backup strategy in your environment?
It’s very open ended Question:
As per my understanding, normally Organizations follow below standards
Prod/QA Environment:
For Small size databases (<200 GB)
• Full Backup – Daily
• Differential Backups – NA
• Transaction Log backups – Every 10-15 minutes depending upon the RPO
For Large size databases (>=200 GB)
• Full Backup – Weekly
• Differential Backups – Daily
• Transaction Log backups – Every 10-15 minutes depending upon the RPO
Again it all depends upon the criticality of the database e.g. for Data warehousing databases it may be possible that there is no
requirement of Transaction log backups.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment