How should you complete the Transact-SQL statement?

HOTSPOT

You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named DB1 that is backed up to a file named D:DB1.bak.

You plan to deploy an Always On availability group that will have the following configurations:

✑ VM1 will host the primary replica of DB1.

✑ VM2 will host a secondary replica of DB1.

You need to prepare the secondary database on VM2 for the availability group.

How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

View Answer

Answer:

Explanation:

Graphical user interface, text, application, chat or text message

Description automatically generated