Exit 70-764 Administering a SQL Database Infrastructure
Question 2 of 5
0% complete
Q2 Single choice

You maintain two Microsoft SQL Server instances that are hosted on two servers named SVR1 and SVR2.
You configure log shipping using the following information:

DB1 on SVR1 is configured as the primary database Logs are backed up to a shared folder on SVR1 DB2 on SVR2 is configured as the secondary database

The service accounts for SQL Server Agent are set up using different domain accounts.

After changes are made to SVR1, log shipping is failing with the following error message:

You need to resolve the issue.

What should you do?

  • A

    Create a new proxy account named PRX1 on SVR2. Grant PRX1 read access to the log copy destination folder on SVR2. Then, configure the copy job to run as PRX1.

  • B

    Configure the log backup shared folder to ensure the SQL Server Agent service account on SVR2 has read access.

  • C

    Create a new proxy account named PRX1 on SVR1. Grant PRX1 write access to the log backup shared folder. Then, configure the backup job to run as PRX1.

  • D

    Configure the log backup shared folder to ensure the SQL Server Agent service account in SVR1 has read access.

Previous Next