How does the script affect the environment?

HOTSPOT

You are configuring log shipping for a Microsoft SQL Server database named salesOrders.

You run the following Transact-SQL script:

You need to determine the changes that the script has on the environment.

How does the script affect the environment? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Box 1: is

The dedicated backup file share is \localhostBackup

Box 2: does not run

The only thing with a name related to ADATM-SQL11 is the schedule name.

Box 3: 72 hours

4320 minutes equals 72 hours.

Note: @backup_retention_period= ] backup_retention_period

Isthe length of time, in minutes, to retain the log backup file in the backup directory on the primary server. backup_retention_period is int, with no default, and cannot be NULL.

Box 4: 15 minutes.

[ @freq_subday_type = ] freq_subday_type

Specifies the units for freq_subday_interval. freq_subday_typeis int, with a default of 0, and can be one of these values.

Here it is 4, which means minutes.

[ @freq_subday_interval = ] freq_subday_interval

The number of freq_subday_type periods to occur between eachexecution of a job. freq_subday_intervalis int, with a default of 0.

Note: Interval should be longer than 10 seconds. freq_subday_interval is ignored in those cases where freq_subday_type is equal to 1.

Here it is 15.

References:

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-schedule-transact-sql

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-log-shipping-primary-database-transact-sql