You are implementing log shipping. You configure a secondary server in standby mode. You configure log shipping to occur hourly and keep up to seven days of log backups.
Users create reports by querying the secondary server. Transaction logs are not applied to the secondary server.
You need to ensure that the secondary server has current data at the beginning of each business day.
What are two possible ways to achieve the goal? Each answer represents a complete solution.
A . Create a snapshot database from a daily backup to use as the secondary database. Revert the snapshot database back to the previous business day.
B . Disconnect users while transaction logs are applied.
C . Configure the secondary server as a database mirroring target server.
D . Allow restore operations to accumulate. Run a Microsoft SQL Agent job that disconnects all users that are connected to the secondary server.
Answer: C,D
Leave a Reply