1 Lets assume you are a DBA and you manage a very large OLAP

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

Solution

Answer

1.

C). Perform a nightly full backup and hourly transaction log backup using SQL Server backup utility

this will ensure that you get the full back without disturbing anybody\'s work and you\'ll have hourly logs which will help you to keep a track on how much has been done or if there is any problem.

2.

D). Setup a standby SQL Server to verify backups

keeping the SQL Server in a standby won\'t provide verification of the backup. hence, it s the least efficient way to verify the backup.