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.Hot Area:

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.Hot Area:

Answer:

Explanation:
Box 1: is
The dedicated backup file share is \\\\localhost\\Backup
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.
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addschedule-transact-sql
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-log-shippingprimary-database-transact-sql



Leave a Reply 2

Your email address will not be published. Required fields are marked *


KTF

KTF

is \\localhost\Backup considered as dedicated fileshare?

it’s localhost
means the backup is stored in the primary server

KTF

KTF

Sorry
The answer is correct

Shared folder can be stored in the primary