Question
1. Lets assume you are a DBA and you manage a very large OLAP database that need to have a backup policy. What is/are your
1. Lets assume you are a DBA and you manage a very large OLAP database that need to have a backup policy. What is/are your best option(s)?
A). Perform a nightly full backup and hourly differential backups using SQL Server backup utility
B). Once a week cold backup should be enough
C). Perform a nightly full backup and hourly transaction log backup using SQL Server backup utility
D). Use database snapshot technology
2. You want to verify your backups. What would you say is the least efficient way to verify the backup?
|
| A). Restore you backups to a test system just to make sure things look good |
| B). | Restore filelistonly command |
| C). | When you setup a backup through SMSS, choose the option to verity the backup. |
| D). | Setup a standby SQL Server to verify backups |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started