Exam 70-764 topic 1 question 43 discussion

Actual exam question from Microsoft's 70-764

Question #: 43
Topic #: 1

HOTSPOT -
You are planning to deploy log shipping for Microsoft SQL Server and store all backups on a dedicated fileshare.
You need to configure the servers to perform each log shipping step.
Which server instance should you configure to perform each action? To answer, select the appropriate server instances in the dialog box in the answer area.
Hot Area:

Show Suggested Answer

Suggested Answer:

Note: Before you configure log shipping, you must create a share to make the transaction log backups available to the secondary server.
SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually. An optional third server instance, known as the monitor server, records the history and status of backup and restore operations and, optionally, raises alerts if these operations fail to occur as scheduled.
Box 1: Primary server instance.
The primary server instance runs the backup job to back up the transaction log on the primary database. backup job: A SQL Server Agent job that performs the backup operation, logs history to the local server and the monitor server, and deletes old backup files and history information. When log shipping is enabled, the job category "Log Shipping Backup" is created on the primary server instance.
Box 2: Secondary server instance
Each of the three secondary server instances runs its own copy job to copy the primary log-backup file to its own local destination folder. copy job: A SQL Server Agent job that copies the backup files from the primary server to a configurable destination on the secondary server and logs history on the secondary server and the monitor server. When log shipping is enabled on a database, the job category "Log Shipping Copy" is created on each secondary server in a log shipping configuration.
Box 3: Secondary server instance.
Each secondary server instance runs its own restore job to restore the log backup from the local destination folder onto the local secondary database. restore job: A SQL Server Agent job that restores the copied backup files to the secondary databases. It logs history on the local server and the monitor server, and deletes old files and old history information. When log shipping is enabled on a database, the job category "Log Shipping Restore" is created on the secondary server instance.
References: https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/about-log-shipping-sql-server

by TheSwedishGuy at Jan. 24, 2020, 11:24 a.m.

Comments

Submit Cancel

course104

4 years, 5 months ago

MSDN: The primary server instance runs the backup job to back up the transaction log on the primary database. This server instance then places the log backup into a primary log-backup file, which it sends to the backup folder. In this figure, the backup folder is on a shared directory-the backup share. Each of the three secondary server instances runs its own copy job to copy the primary log-backup file to its own local destination folder. Each secondary server instance runs its own restore job to restore the log backup from the local destination folder onto the local secondary database.

upvoted 1 times

...

TheSwedishGuy

5 years, 5 months ago

It's like a slower ansynchronous mode, without failover.

upvoted 1 times

...

TheSwedishGuy

5 years, 5 months ago

In this case, the primary creates the baseline for the secondary to first copy the job and then restore from the most recent backup copy.

upvoted 2 times

KC

4 years, 10 months ago

Agreed. https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/about-log-shipping-sql-server?view=sql-server-ver15

upvoted 1 times

...