How should you configure the backup solution?

You work as a Database Administrator (DBA) for a company named ABC.com.

The company uses a Microsoft SQL Server 2012 infrastructure.

The sales and marketing departments contain a total of 60 users. Each user uses a custom application that stores data in a SQL Server database.

Each user has a separate database.

A server named ABC-SQL1 hosts the 60 databases.

You need to configure a backup solution for all the databases.

The solution must ensure that any new databases configured on ABC-SQL1 are automatically added to the backup schedule. The backup schedule consists of a full backup every night, a differential backup every hour and a transaction log backup every 15 minutes.

How should you configure the backup solution?
A . You should configure SQL Server Agent jobs.
B . You should configure Change Data Capture.
C . You should configure Policy-Based Management.
D . You should configure a Maintenance Plan.

View Answer

Answer: D