Which four actions should you perform in sequence?

DRAG DROP

You have a Microsoft SQL Server instance which hosts all of your corporate databases. A database named Sales stores information about customers and their contact information.

You use the following processes for backing up the database:

– All databases are configured for full recovery model.

– Full backups are performed every morning at 2:00 AM.

– Log backups are performed every hour starting at 9:00 AM.

At 9:35 AM, a member of the sales team mistakenly updates all customer records.

You need to recover the database to a stable state and recover as much data as possible without recovering the changes that the sales team member made.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

View Answer

Answer: