Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it As a result these questions will not appear in the review screen.

You have a database named DB1 that is 640 GB and is updated frequently. You enabled log shipping for DB1 and configure backup and restore to occur every 30 minutes. You discover that the disks on the data server are almost full. You need to reduce the amount of disk space used by the log shipping process.

Solution: You enable compression for the transaction log backups:

Does this meet the goal?
A . Yes
B . No

View Answer

Answer: A

Explanation:

SQL Server 2017 supports backup compression. When creating a log shipping configuration, you can control the backup compression behavior of log backups by choosing one of the following options: Use the default server setting, Compress backup, or Do not compress backup

Note: SQL Server 2008 Enterprise and later versions support backup compression.

References: https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/configure-log­shipping-sql-server?view=sql-server-2017