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 the stated 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 enable log shipping for DB1 and configure backup and restore to occur every 30 minutes.
You discover that the hard disks on the database server are almost full.
You need to reduce the amount of disk space used by the log shipping process.
Solution: You reduce the frequency of the transaction log backups to once per hour.
Does this meet the goal?
A . Yes
B . No
Answer: B
Explanation:
You should compress the transaction log backups.
References: https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/configure-logshipping-sql-server?view=sql-server-2017
Leave a Reply