You have the following servers:
SQL1 hosts a database named DB1.
Users in the branch office must be able to access DB1 from SQL3.
You need to configure log shipping on DB1 from the main office to the branch office.
On which server should you configure the backup job?
A . SQL3
B . SQL1
C . SQL2
D . FS1
Answer: B
Explanation:
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.
Note: 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.
References: https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/about-log-shipping-sql-server
Leave a Reply