QuestionQ71

VerifiedMonitor, configure, and optimize database resources

You deploy a SQL Server instance on Azure Virtual Machines named SQL1 that hosts multiple databases.

You configure the full recovery model for every database.

You perform a full backup of the master database on SQL1.

You need to perform an additional backup of the master database on SQL1. The solution must minimize the time required to perform the backup.

Which backup type should you perform?

Explanation

SQL Server supports only full database backups for the master database. Differential backups and transaction log backups are not supported for master; consequently, a tail-log backup is not supported either.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!